Thread

1. Verifying transaction success

   Alfonso Peniche <alfonso@iteso.mx> — 2001-02-03T00:37:28Z

   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.
   
   
   

2. plpgsql rowsupdated Re: Verifying transaction success

   alex@pilosoft.com — 2001-02-03T01:12:52Z

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