Horton

Re: 2PC-induced lockup

Heikki Linnakangas <heikki@enterprisedb.com>

View thread View on postgr.es
From: Heikki Linnakangas <heikki@enterprisedb.com>
To: Peter Eisentraut <peter_e@gmx.net>
Cc: pgsql-hackers@postgresql.org, Chris Browne <cbbrowne@acm.org>
Date: 2007-07-11T19:12:11Z
Lists: pgsql-hackers 
Peter Eisentraut wrote:
> Heikki Linnakangas wrote:
>> It's not? I agree with Tom here; this is just one of the numerous
>> things you can do to screw up your database as a superuser. Why would
>> you LOCK the pg_auth table, or any other system table for that
>> matter, in the first place? Let alone in a distributed transaction.
> 
> Well, my test case arose from a real application scenario, not an 
> attempt to destroy my database system.

Why does the application LOCK pg_auth?

-- 
   Heikki Linnakangas
   EnterpriseDB   http://www.enterprisedb.com