| From: | "Owen Jacobson" <ojacobson(at)osl(dot)com> |
|---|---|
| To: | Joÿffffffffffe3o Carvalho <joaocarvalho127(at)yahoo(dot)com(dot)br>, "PG-SQL lista de mail" <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: Turn off auto-commit |
| Date: | 2005-09-02 17:27:06 |
| Message-ID: | 144D12D7DD4EC04F99241498BB4EEDCC08AD20@nelson.osl.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)postgresql(dot)org [mailto:pgsql-sql-owner(at)postgresql(dot)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/>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | leon | 2005-09-02 19:15:46 | Recommendation on bytea or blob for binary data like images |
| Previous Message | Joÿffffffffffe3o Carvalho | 2005-09-02 17:21:41 | Turn off auto-commit |