Thread: off topic rollback

sorry for this off topic

but someone ask me: if i do a invalid query in the middle of a transaction
i need to do a rollback .

________________________________________
A busca mais veloz e precisa da internet. Acesse agora: http://www.zoom.com.br.

with auttocommit set to true there is no problem
 '>'-- Mensagem Original --
 '>'Date: Thu, 8 Aug 2002 14:30:49 -0300
 '>'From: angelo.rigo@globo.com
 '>'Subject: [PHP] off topic rollback
 '>'To: pgsql-php@postgresql.org
 '>'
 '>'
 '>'sorry for this off topic
 '>'
 '>'but someone ask me: if i do a invalid query in the middle of a transaction
 '>'i need to do a rollback .
 '>'
 '>'________________________________________
 '>'A busca mais veloz e precisa da internet. Acesse agora: http://www.zoom.com.br.
 '>'
 '>'
 '>'
 '>'---------------------------(end of broadcast)---------------------------
 '>'TIP 6: Have you searched our list archives?
 '>'
 '>'http://archives.postgresql.org


________________________________________
A busca mais veloz e precisa da internet. Acesse agora: http://www.zoom.com.br.

On Thu, 8 Aug 2002 angelo.rigo@globo.com wrote:

> sorry for this off topic
>
> but someone ask me: if i do a invalid query in the middle of a transaction
> i need to do a rollback .

Basically, in PHP, just about any error will cause the current transaction
to fail and rollback automatically and completely.  You don't have to
clean up the mess, as it's already cleaned up for you.

Then you can just try running the transaction again and see if it goes
through.