Обсуждение: 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.