Re: No json results are shown in Data Output tab.

Hi Aditya,

Thanks for the quick response and the fix.

Great.

Kind regards,

Henk F. van Til

----- Original Message ----

From: Aditya Toshniwal

To: "Henk F. van Til"

Cc: "pgadmin-support lists.postgresql.org"

Sent: Don, 28 Mrt 2019 13:35

Subject: Re: No json results are shown in Data Output tab.

blockquote{margin:0px;}

Hi Henk,

We have fixed the issue under bug - https://redmine.postgresql.org/issues/4105

The fix will be available in v4.4.

On Thu, Mar 28, 2019 at 5:11 PM Henk F. van Til wrote:

Hi,

Version: pgAdmin4 v4.3

When executing a query  the result is shown in the tab 'Data Output'. 

For example: SELECT * FROM table_foo LIMIT 5;

But when I run a function with json output, nothing is shown in the tab 'Data Output'. All notice messages are displayed in the 'Messages' tab including the messages 'Successfully run. Total query runtime: 64 msec. 1 rows affected.'

For example: SELECT function_foo('{"var1": "text", "var2": "text2"}');

When running the same function using the option 'download as CSV', I have the results.

Is this a setting in 'Preferences' which I overlooked. It worked in a previous version of pgAdmin4.

Thanks

Henk F. van Til

--

Thanks and Regards,

Aditya Toshniwal

Software Engineer | EnterpriseDB Software Solutions | Pune

"Don't Complain about Heat, Plant a tree"