Re: python function

Поиск
Список
Период
Сортировка
От Guillermo E. Villanueva
Тема Re: python function
Дата
Msg-id CANm+PCCQjxSt6Y_hovXQCoNr8eQM3QATGcSJQadKei2rZG0Y-g@mail.gmail.com
обсуждение исходный текст
Ответ на Re: python function  (Ashesh Vashi <ashesh.vashi@enterprisedb.com>)
Ответы Re: python function
Список pgadmin-support
Дерево обсуждения
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




Вложения

В списке pgadmin-support по дате отправления: