Re: How to prevent vacuum and reindex from deadlocking. - Mailing list pgsql-general

From Dennis Gearon
Subject Re: How to prevent vacuum and reindex from deadlocking.
Date
Msg-id 3F3A586D.70505@cvc.net
Whole thread Raw
In response to Re: How to prevent vacuum and reindex from deadlocking.  (Robert Creager <Robert_Creager@LogicalChaos.org>)
List 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 by date:

Previous
From: Teodor Sigaev
Date:
Subject: Re: Tsearch2 lexeme position
Next
From: Josh Berkus
Date:
Subject: Re: Commercial support?