Re: How to set "auto commit" off in postgresql db?

Поиск
Список
Период
Сортировка
От J.H.M. Dassen (Ray)
Тема Re: How to set "auto commit" off in postgresql db?
Дата
Msg-id 20010111222628.A23245@cistron-office.nl
обсуждение исходный текст
Ответ на How to set "auto commit" off in postgresql db?  ("Guang Mei" <zlmei@hotmail.com>)
Список 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

В списке pgsql-general по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: Re: COPY error: pqReadData() -- backend closed the channel unexpectedly
Следующее
От: "Gregory Wood"
Дата:
Сообщение: Re: How to set "auto commit" off in postgresql db?