python function - Mailing list pgadmin-support

From Guillermo E. Villanueva
Subject python function
Date
Msg-id CANm+PCDrMF3MzpDZJh8uWAjkT6r+1B6woYR8EWvVrGYdj3mx0w@mail.gmail.com
Whole thread Raw
Responses Re: python function  (Ashesh Vashi <ashesh.vashi@enterprisedb.com>)
List pgadmin-support
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>
Attachment

pgadmin-support by date:

Previous
From: Dave Page
Date:
Subject: Re: pgAdmin4, how to customize sql panel font size
Next
From: Ashesh Vashi
Date:
Subject: Re: python function