Multiple result set not displayed in PgAdmin4

From: "Muthukumar(dot)GK" <muthankumar(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Multiple result set not displayed in PgAdmin4
Date: 2020-11-23 04:53:29
Message-ID: CA+rAWgkvCSkCF13p-g900rG0_J9USRdPrfauspCi-evnyaQgzA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi Team,

I have created function in postgre sql 13 which will return two result.
But when execute i can able to see the last cursor (query result set of
last select )result set in Data output window of Pgadmin4. i tried
executing the cursor inside the transaction as well (BEING.....COMMIT).
but i still do not see both result set one by one (likeSQL) in data output
window. Please let me know if there is any limitation in pgadmin4 tool that
multiple result set will not be displayed in Data output Window.

Regards
Muthukumar

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jagmohan Kaintura 2020-11-23 08:36:00 ERROR : invalid transaction termination : PostgreSQL v12
Previous Message Hagen Finley 2020-11-22 23:28:04 Re: INSERT Trigger to check for existing records