Re: A bad behavior under autocommit off mode

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: A bad behavior under autocommit off mode
Дата
Msg-id 200303200456.h2K4uRP22779@candle.pha.pa.us
обсуждение исходный текст
Ответ на Re: A bad behavior under autocommit off mode  (Neil Conway <neilc@samurai.com>)
Ответы Re: A bad behavior under autocommit off mode  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Neil Conway wrote:
> On Wed, 2003-03-19 at 23:36, Bruce Momjian wrote:
> > I don't like pushing autocommit to the client.
> 
> It seems like a good idea to me, particularly since the current
> server-side implementation is such a kludge. Can you go over your
> objections to client-side autocommit again?

First, I am afraid a kludge on the server is going to become 10 client
kludges.  I also don't see how it can be easily controlled in the
application without adding an API function for every language --- adding
it to libpq will require new API's in perhaps 7 different languages.

I think our SET functionality is easy to understand and use.  I don't
see pushing it into the client as greatly improving things, and could
make things worse.  If we can't get it right in the backend, how many
clients are going to do it wrong?

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073
 


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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: A bad behavior under autocommit off mode
Следующее
От: "Vadim Mikheev"
Дата:
Сообщение: Re: Nested transactions: low level stuff