Re: How to prevent vacuum and reindex from deadlocking.

Поиск
Список
Период
Сортировка
От Robert Creager
Тема Re: How to prevent vacuum and reindex from deadlocking.
Дата
Msg-id 20030812220604.1eecae67.Robert_Creager@LogicalChaos.org
обсуждение исходный текст
Ответ на Re: How to prevent vacuum and reindex from deadlocking.  (Dennis Gearon <gearond@cvc.net>)
Ответы Re: How to prevent vacuum and reindex from deadlocking.
Re: How to prevent vacuum and reindex from deadlocking.
Список pgsql-general
On Tue, 12 Aug 2003 08:13:59 -0700
Dennis Gearon <gearond@cvc.net> said something like:

> Postgres itself doesn't support nested transactions.
>

Yea, I just convinced myself of that.  The first time I read the docs, that's
what I thought.  Then I convinced myself when I re-read them that it was just a
warning, and a new transaction was started.  But I just tried it, and they're
not...

Thanks for point that out to me.  I dare say that the BEGIN documentation is
unclear to me, even knowing what I know now.  Why not just explictly say "Nested
transactions are not supported", rather than "...  The current transaction is
not affected".  Alright, maybe I still read at Junior High level.

Cheers,
Rob

--
 21:59:11 up 11 days, 14:43,  4 users,  load average: 2.17, 2.10, 2.02

Вложения

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

Предыдущее
От: "Envex Developments"
Дата:
Сообщение: Installing DBD::Pg Perl module locally
Следующее
От: Jerome Macaranas
Дата:
Сообщение: Viewing Client Connections..