Re: 2PC-induced lockup - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: 2PC-induced lockup
Date
Msg-id 200707112208.13392.peter_e@gmx.net
Whole thread Raw
In response to Re: 2PC-induced lockup  (Heikki Linnakangas <heikki@enterprisedb.com>)
List pgsql-hackers
Heikki Linnakangas wrote:

> Why does the application LOCK pg_auth?

It does it with NOWAIT to determine if some other connection had already 
locked it (because it was modifying some roles) in order not to lock up 
the program.  This (or something like it, because this doesn't work, 
after all) is unfortunately necessary because schema changes don't obey 
ordinary snapshot rules.

-- 
Peter Eisentraut
http://developer.postgresql.org/~petere/


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: 2PC-induced lockup
Next
From: Heikki Linnakangas
Date:
Subject: Re: 2PC-induced lockup