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
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 transact=
ion
'>'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.
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly
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.
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html