Re: python function

From: "Guillermo E(dot) Villanueva" <guillermovil(at)gmail(dot)com>
To: Ashesh Vashi <ashesh(dot)vashi(at)enterprisedb(dot)com>
Cc: pgadmin-support <pgadmin-support(at)postgresql(dot)org>
Subject: Re: python function
Date: 2016-08-18 10:45:27
Message-ID: CANm+PCB_YboF78Ho4nMZ8rZEzY+nexagv_8GQO_RS1=wd9=eUQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

2016-08-18 7:44 GMT-03:00 Guillermo E. Villanueva <guillermovil(at)gmail(dot)com>:

>
>
> 2016-08-18 7:28 GMT-03:00 Ashesh Vashi <ashesh(dot)vashi(at)enterprisedb(dot)com>:
>
>> 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>
>>>>
>>>>
>>>
>>
>

Attachment Content-Type Size
pgadmin4.rar application/rar 24.8 KB

In response to

Browse pgadmin-support by date

  From Date Subject
Next Message Guillermo E. Villanueva 2016-08-18 12:29:31 multi-insert
Previous Message Ashesh Vashi 2016-08-18 10:28:12 Re: python function