Re: How to prevent vacuum and reindex from deadlocking.

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
>