Re: SET autocommit begins transaction?

Поиск
Список
Период
Сортировка
От Rod Taylor
Тема Re: SET autocommit begins transaction?
Дата
Msg-id 1032395130.47165.6.camel@jester
обсуждение исходный текст
Ответ на Re: SET autocommit begins transaction?  (Bruce Momjian <pgman@candle.pha.pa.us>)
Ответы Re: SET autocommit begins transaction?  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список pgsql-bugs
> > What about that doesn't make sense?  Having SET begin a transaction
> > seems like a gross violation of POLS and likely to contradict the spec
> > and cause problems with many applications.  -sc
>
> I think we left the standard when we made SET rollbackable.  Maybe that
> has to be reopened because if we did that, it would make perfect sense
> because all SETs would be outside transactions.

Of course, the reason they're rollbackable is:

begin;
create schema newschema;
set search_path = newschema;
rollback;

create table junk;  -- DOH!

--
  Rod Taylor

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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: SET autocommit begins transaction?
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: SET autocommit begins transaction?