> From: Medhavi Mahansaria
>To: Adrian Klaver
>Cc: "pgsql-general@postgresql.org"
>Sent: Tuesday, 17 March 2015, 14:30
>Subject: Re: [GENERAL] Reg: PL/pgSQL commit and rollback
>
>
>
>Yes. I have read this document.
>
>But my issue is that
On 17 March 2015 at 15:30, Medhavi Mahansaria
wrote:
> Yes. I have read this document.
>
> But my issue is that even when it throws and exception I need to rollback
> the changes made by that query and move on to the next block.
>
> Is there any way to accomplish that?
Please do not toppost on th
On 03/17/2015 07:30 AM, Medhavi Mahansaria wrote:
Yes. I have read this document.
But my issue is that even when it throws and exception I need to
rollback the changes made by that query and move on to the next block.
Is there any way to accomplish that?
"If no error occurs, this form of bloc
Services
Business Solutions
Consulting
From: Adrian Klaver
To: Medhavi Mahansaria ,
"pgsql-general@postgresql.org"
Date: 03/17/2015 07:29 PM
Subject: Re: [GENERAL] Reg: PL/pgSQL commit and rollback
O
Medhavi Mahansaria wrote:
> I am writing a porting a procedure running in oracle to a PL/pgSQL function.
>
> I need to use commit and rollback in my function.
>
> I have read that usage of commit and rollback is not possible in PL/pgSQL,
> however savepoints can be
> used.
>
> even when i use s
On 03/17/2015 06:50 AM, Medhavi Mahansaria wrote:
Hi,
I am writing a porting a procedure running in oracle to a PL/pgSQL
function.
I need to use commit and rollback in my function.
I have read that usage of commit and rollback is not possible in
PL/pgSQL, however savepoints can be used.
even
Hi,
I am writing a porting a procedure running in oracle to a PL/pgSQL
function.
I need to use commit and rollback in my function.
I have read that usage of commit and rollback is not possible in PL/pgSQL,
however savepoints can be used.
even when i use savepoints and rollback to a savepoint
