| From: | "J(dot)H(dot)M(dot) Dassen (Ray)" <jdassen(at)cistron-office(dot)nl> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: How to set "auto commit" off in postgresql db? |
| Date: | 2001-01-11 21:26:28 |
| Message-ID: | 20010111222628.A23245@cistron-office.nl |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
[Please don't mail in HTML]
On Thu, Jan 11, 2001 at 21:02:56 -0000, Guang Mei wrote:
> It seems to me that postgresql db's default set for commit is "on".
Erm, it's not PostgreSQL itself, but rather the "psql" interface.
> I would like to set it to "off". How could I do that?
By explicitly starting a transaction through "BEGIN WORK".
HTH,
Ray
--
FUD for dummies by example in 21 days Lesson 3: use braindead analogies.
"Open source raises various security issues. How many banks will tell you
where their cameras are and where their vaults are?"
A Microsoft droid in http://www.zdnet.co.uk/news/1999/47/ns-11895.html
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gregory Wood | 2001-01-11 21:28:58 | Re: How to set "auto commit" off in postgresql db? |
| Previous Message | Bruce Momjian | 2001-01-11 21:25:22 | Re: Re: COPY error: pqReadData() -- backend closed the channel unexpectedly |