Обсуждение: Verifying transaction success

Поиск
Список
Период
Сортировка

Verifying transaction success

От
Alfonso Peniche
Дата:
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

От
Alex Pilosov
Дата:
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.
>
>