Re: How to prevent vacuum and reindex from deadlocking.

Поиск
Список
Период
Сортировка
От Dennis Gearon
Тема Re: How to prevent vacuum and reindex from deadlocking.
Дата
Msg-id 3F3A586D.70505@cvc.net
обсуждение исходный текст
Ответ на Re: How to prevent vacuum and reindex from deadlocking.  (Robert Creager <Robert_Creager@LogicalChaos.org>)
Список pgsql-general
In general, the documentation is not direct. When it is, it often is using database theory language, masters level
databaseengineer language. 

Robert Creager wrote:

> 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
>


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

Предыдущее
От: Teodor Sigaev
Дата:
Сообщение: Re: Tsearch2 lexeme position
Следующее
От: Josh Berkus
Дата:
Сообщение: Re: Commercial support?