| 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:25:10 |
| Message-ID: | CANm+PCCQjxSt6Y_hovXQCoNr8eQM3QATGcSJQadKei2rZG0Y-g@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgadmin-support |
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 | Ashesh Vashi | 2016-08-18 10:28:12 | Re: python function |
| Previous Message | Ashesh Vashi | 2016-08-18 03:25:43 | Re: python function |