plpgsql rowsupdated Re: Verifying transaction success

From: Alex Pilosov <alex(at)pilosoft(dot)com>
To: Alfonso Peniche <alfonso(at)iteso(dot)mx>
Cc: pgsql-general(at)postgresql(dot)org
Subject: plpgsql rowsupdated Re: Verifying transaction success
Date: 2001-02-03 01:12:52
Message-ID: Pine.BSO.4.10.10102022010400.10437-100000@spider.pilosoft.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.
>
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Stephane 2001-02-03 02:11:47 how to make my own database
Previous Message Mitch Vincent 2001-02-03 00:54:02 Re: pg_dump shell or php?