On Wed, Mar 5, 2008 at 3:41 PM, Pavan Deolasee <pavan.deolasee@gmail.com> wrote:
>
>
>
> Two backends try to vacuum full two different catalog tables. Each acquires an
> exclusive lock on the respective catalog relation. Then each try to
> initialize its
> own catalog cache. But to do that they need AccessShareLock on each other's
> table leading to a deadlock.
>
Well I could reproduce the above mentioned deadlock scenario with two system
relations. So that validates the theory.
Thanks,
Pavan
--
Pavan Deolasee
EnterpriseDB http://www.enterprisedb.com