turning off autocommit behavior in psql

Поиск
Список
Период
Сортировка
От David Van Wie
Тема turning off autocommit behavior in psql
Дата
Msg-id 20020822093642.Q48130-200000@radix.cryptio.net
обсуждение исходный текст
Ответы Re: turning off autocommit behavior in psql
Список pgsql-hackers
Hi,

I've been using postgres for a little over a year now, and overall I've
been very pleased with it. Thanks!

The psql client is really nice, but I was frustrated by the lack of a
"no-autocommit" mode. So, I made a few small modifications to the client
to wrap everything in a transaction block automatically. I've been using
it locally for a while, and it seems to work alright. The patch is
attached (it's a patch to the 7.2.1 branch).

Do other people think this is a useful feature?

The one thing that I don't like about the patch, but that I'm not sure how
to handle, is telling the user that one transaction has ended and another
has begun. Currently, I am just printing NOTICE messages ("NOTICE:
aborting current transaction and beginning a new one", for example) but
this seems wrong, since the messages aren't coming from the backend.
Suggestions on how to handle this?

...dave

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

Предыдущее
От: Thomas O'Connell
Дата:
Сообщение: recent security activity
Следующее
От: Tom Lane
Дата:
Сообщение: Re: turning off autocommit behavior in psql