Postgres Pro
Downloads
Home   >   mailing lists

Re: python function - Mailing list pgadmin-support

From Guillermo E. Villanueva
Subject Re: python function
Date
Msg-id CANm+PCCQjxSt6Y_hovXQCoNr8eQM3QATGcSJQadKei2rZG0Y-g@mail.gmail.com
Whole thread Raw
In response to Re: python function  (Ashesh Vashi <ashesh.vashi@enterprisedb.com>)
Responses Re: python function  (Ashesh Vashi <ashesh.vashi@enterprisedb.com>)
List pgadmin-support
Tree view
where is the pgadmin4 log?

2016-08-18 0:25 GMT-03:00 Ashesh Vashi <ashesh.vashi@enterprisedb.com>:

On Wed, Aug 17, 2016 at 10:12 PM, Guillermo E. Villanueva <guillermovil@gmail.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:

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




Attachment

pgadmin-support by date:

Previous
From: Ashesh Vashi
Date:
Subject: Re: python function
Next
From: Ashesh Vashi
Date:
Subject: Re: python function