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

From Heikki Linnakangas
Subject Re: 2PC-induced lockup
Date
Msg-id 46952B8B.1090401@enterprisedb.com
Whole thread Raw
In response to Re: 2PC-induced lockup  (Peter Eisentraut <peter_e@gmx.net>)
Responses Re: 2PC-induced lockup  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: 2PC-induced lockup  (Peter Eisentraut <peter_e@gmx.net>)
List 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


pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: 2PC-induced lockup
Next
From: Tom Lane
Date:
Subject: Re: 2PC-induced lockup