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
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
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
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/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
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
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 ,
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
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
>>
>>
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
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 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) :=
12 matches
Mail list logo
