On Mon, Nov 23, 2020 at 6:52 PM Jagmohan Kaintura
wrote:
> It doesn't works putting that block inside additional BEGIN END
>
> CREATE OR REPLACE PROCEDURE TEST_TRANSACTION(
> )
> LANGUAGE 'plpgsql'
> SECURITY DEFINER
> AS $BODY$
> DECLARE
> G_LAST_UPDATE_USER_SYSTEM VARCHAR2(6) :=
It doesn't works putting that block inside additional BEGIN END
CREATE OR REPLACE PROCEDURE TEST_TRANSACTION(
)
LANGUAGE 'plpgsql'
SECURITY DEFINER
AS $BODY$
DECLARE
G_LAST_UPDATE_USER_SYSTEM VARCHAR2(6) := 'SYSTEM';
G_LAST_UPDATE_MODULE_BATCH VARCHAR2(5) := 'BATCH';
G_CNT
On Mon, Nov 23, 2020 at 10:03 AM Jagmohan Kaintura
wrote:
> Hi ,
> The Block is only failing immediately at First COMMIT only. It's not
> supporting COMMIT. I have removed some portion of code before the second
> COMMIT.
>
Please don't top-post on the Postgres lists by the way (reply with all
p
Howdy,
I believe you would receive more help from the proper forum for PgAdmin4:
https://www.pgadmin.org/support/list/
This is a list for PostgreSQL and it's software. PostgreSQL's client is
psql which is a command line client.
Thanks!
JD
>>
>>
Hi ,
The Block is only failing immediately at First COMMIT only. It's not
supporting COMMIT. I have removed some portion of code before the second
COMMIT.
On Mon, Nov 23, 2020 at 9:19 PM Adrian Klaver
wrote:
> On 11/23/20 12:36 AM, Jagmohan Kaintura wrote:
> > Hi Team,
> >
> > We have many BAT
Hi,
I am testing things on hash aggregate spilling in version 13.1 and am
struggling to understand the partition thing in the two explains below.
My understanding is that a partition corresponds to a spill file which will
be treated in a later batch (which can re-spill in some cases).
Am I right
Hi Adrian,
If PG admin 4 return only last result set then, how can we call the
procedure/function to get the multiple result set from dot net application.
we are planning to migrate things from SQL to postgresql.. most of our
existing SQL stored procedures will return multiple result sets. So we
On 11/23/20 8:07 AM, Muthukumar.GK wrote:
Hi Adrian,
If PG admin 4 return only last result set then, how can we call the
procedure/function to get the multiple result set from dot net application.
pgAdmin4 != Postgres, it is just a GUI client and in this case has a
limitation.
Run the pr
On 11/23/20 12:36 AM, Jagmohan Kaintura wrote:
Hi Team,
We have many BATCH JOBS in Oracle which we are committing after
processing few Records. These batch Jobs process in some subsets and
call transaction control statements COMMIT in case of Success and
ROLLBACK in case of failure.
While c
On 11/22/20 8:53 PM, Muthukumar.GK wrote:
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
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
Hi Team,
We have many BATCH JOBS in Oracle which we are committing after processing
few Records. These batch Jobs process in some subsets and call transaction
control statements COMMIT in case of Success and ROLLBACK in case of
failure.
While converting to POstgreSQL we converted in Same Format w
12 matches
Mail list logo
