| From: | "Guillermo E(dot) Villanueva" <guillermovil(at)gmail(dot)com> |
|---|---|
| To: | pgadmin-support <pgadmin-support(at)postgresql(dot)org> |
| Subject: | python function |
| Date: | 2016-08-17 16:42:09 |
| Message-ID: | CANm+PCDrMF3MzpDZJh8uWAjkT6r+1B6woYR8EWvVrGYdj3mx0w@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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:*
[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>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ashesh Vashi | 2016-08-18 03:25:43 | Re: python function |
| Previous Message | Dave Page | 2016-08-17 12:46:57 | Re: pgAdmin4, how to customize sql panel font size |