Thread: Verifying transaction success

Verifying transaction success

From
Alfonso Peniche
Date:
Is there a way (in plpgsql) to know if an insert, update or delete
instruction was successful without having to run a select statement
after either one?

Something like an error flag, a set of instructions, a process...

Thanks again.


plpgsql rowsupdated Re: Verifying transaction success

From
Alex Pilosov
Date:
Not 'transaction'. If previous operation _failed_, you won't even get to
next instruction. What you are asking whether previous statement updated
any rows. I _think_ in 7.1 you can do that, but I don't remember how.

-alex

On Fri, 2 Feb 2001, Alfonso Peniche wrote:

> Is there a way (in plpgsql) to know if an insert, update or delete
> instruction was successful without having to run a select statement
> after either one?
>
> Something like an error flag, a set of instructions, a process...
>
> Thanks again.
>
>