| From: | Ashesh Vashi <ashesh(dot)vashi(at)enterprisedb(dot)com> |
|---|---|
| To: | "Guillermo E(dot) Villanueva" <guillermovil(at)gmail(dot)com> |
| Cc: | pgadmin-support <pgadmin-support(at)postgresql(dot)org> |
| Subject: | Re: python function |
| Date: | 2016-08-18 03:25:43 |
| Message-ID: | CAG7mmozx-U6nJYKzRrk=btXjTWheYDAjoPCu4pUhM1iD3mGobw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgadmin-support |
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 | Guillermo E. Villanueva | 2016-08-18 10:25:10 | Re: python function |
| Previous Message | Guillermo E. Villanueva | 2016-08-17 16:42:09 | python function |