pg.ddx.io pgsql-sql@postgresql.org mailing list archivehelp / color / mirror / Atom feed
Turn off auto-commit 2+ messages / 2 participants [nested] [flat]
* Turn off auto-commit @ 2005-09-02 17:21 Joÿffffffffffe3o Carvalho <joaocarvalho127@yahoo.com.br> 0 siblings, 0 replies; 2+ messages in thread From: Joÿffffffffffe3o Carvalho @ 2005-09-02 17:21 UTC (permalink / raw) To: pgsql-sql 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 João Carvalho --------------------------------- Yahoo! Messenger com voz: PROMOÇÃO VOCÊ PODE LEVAR UMA VIAGEM NA CONVERSA. Participe! ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Turn off auto-commit @ 2005-09-02 17:27 Owen Jacobson <ojacobson@osl.com> 0 siblings, 0 replies; 2+ messages in thread From: Owen Jacobson @ 2005-09-02 17:27 UTC (permalink / raw) To: Joÿffffffffffe3o Carvalho <joaocarvalho127@yahoo.com.br>; pgsql-sql 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-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 João Carvalho _____ Yahoo! Messenger com voz: PROMOÇÃO VOCÊ PODE LEVAR UMA VIAGEM NA CONVERSA. Participe! <http://us.rd.yahoo.com/mail/br/taglines/*http://br.yahoo.com/messenger/promocao/; ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2005-09-02 17:27 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2005-09-02 17:21 Turn off auto-commit Joÿffffffffffe3o Carvalho <joaocarvalho127@yahoo.com.br> 2005-09-02 17:27 Re: Turn off auto-commit Owen Jacobson <ojacobson@osl.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox