View Single Post

   
  #4 (permalink)  
Old 04-16-2008, 12:36 AM
Scott Marlowe
 
Posts: n/a
Default Re: how to continue using a connection after an error withautocommit=false

On Tue, 2007-02-20 at 04:53, Altaf Malik wrote:
> You can either commit or rollback the transaction when you encounter
> an SQL error. This will alow the next statements to execute
> successfully.


You can't commit after an error in PostgreSQL unless you've rolled back
to a savepoint from before the error.

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

Reply With Quote