From: | Ashesh Vashi <ashesh(dot)vashi(at)enterprisedb(dot)com> |
---|---|
To: | "Guillermo E(dot) Villanueva" <guillermovil(at)gmail(dot)com> |
Cc: | pgadmin-support <pgadmin-support(at)postgresql(dot)org> |
Subject: | Re: python function |
Date: | 2016-08-18 10:28:12 |
Message-ID: | CAG7mmow2=WnigMDnhAWBz04_+o=OJzbfZuG8AhdzBOsOKmYWdg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
In the home directory of the user, who is running the pgAdmin 4 (unless
you've changed that in config.py/config_local.py).
On non-windows:
$HOME/.pgadmin/pgadmin4.log
On windows
%APPDATA%\pgAdmin\pgadmin4.log
--
Thanks & Regards,
Ashesh Vashi
EnterpriseDB INDIA: Enterprise PostgreSQL Company
<http://www.enterprisedb.com>
*http://www.linkedin.com/in/asheshvashi*
<http://www.linkedin.com/in/asheshvashi>
On Thu, Aug 18, 2016 at 3:55 PM, Guillermo E. Villanueva <
guillermovil(at)gmail(dot)com> wrote:
> where is the pgadmin4 log?
>
> 2016-08-18 0:25 GMT-03:00 Ashesh Vashi <ashesh(dot)vashi(at)enterprisedb(dot)com>:
>
>>
>> On Wed, Aug 17, 2016 at 10:12 PM, Guillermo E. Villanueva <
>> guillermovil(at)gmail(dot)com> wrote:
>>
>>> I have the next python function:
>>> CREATE OR REPLACE FUNCTION fn_detalle()
>>> RETURNS setof news AS
>>> $$
>>> myquery="""
>>> select *
>>> from news
>>> """
>>> res = plpy.execute(myquery)
>>> return res
>>> $$
>>> LANGUAGE plpython3u
>>>
>>> *In pgadmin3 work ok:*
>>>
>>> [image: Imágenes integradas 1]
>>> but in pgadmin4 beta 4
>>> when I try :
>>> select * from fn_news()
>>> I have:
>>>
>>> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2 Final//EN">
>>> <title>500 Internal Server Error</title>
>>> <h1>Internal Server Error</h1>
>>> <p>The server encountered an internal error and was unable to complete
>>> your request. Either the server is overloaded or there is an error in the
>>> application.</p>
>>>
>> This suggests issue in the pgadmin 4 backend.
>>
>> Can you share the pgadmin4 logs?
>>
>>
>> --
>>
>> Thanks & Regards,
>>
>> Ashesh Vashi
>> EnterpriseDB INDIA: Enterprise PostgreSQL Company
>> <http://www.enterprisedb.com/>
>>
>>
>> *http://www.linkedin.com/in/asheshvashi*
>> <http://www.linkedin.com/in/asheshvashi>
>>
>>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Guillermo E. Villanueva | 2016-08-18 10:45:27 | Re: python function |
Previous Message | Guillermo E. Villanueva | 2016-08-18 10:25:10 | Re: python function |