Thread: Turn off auto-commit
Im working in postgresql 8.0 in windows XP. How can I turn off auto-commit.
I already tried a few things but it didn't worked.
Regards
Regards
João Carvalho
Yahoo! Messenger com voz: PROMOÇÃO VOCÊ PODE LEVAR UMA VIAGEM NA CONVERSA. Participe!
You can turn off autocommit by explicitly starting a transaction (eg. with BEGIN; in psql or by turning off autocommit through ODBC). Statements inside the transaction will not have their own, automatically-commited transactions.
HTH,
Owen
-----Original Message-----
From: pgsql-sql-owner@postgresql.org [mailto:pgsql-sql-owner@postgresql.org]On Behalf Of Joÿffffffffffe3o Carvalho
Sent: Friday, September 02, 2005 10:22 AM
To: PG-SQL lista de mail
Subject: [SQL] Turn off auto-commitIm working in postgresql 8.0 in windows XP. How can I turn off auto-commit.I already tried a few things but it didn't worked.
RegardsJoão Carvalho
Yahoo! Messenger com voz: PROMOÇÃO VOCÊ PODE LEVAR UMA VIAGEM NA CONVERSA. Participe!