Re: pg_dump and dependencies and --section ... it's a mess
Tom Lane <tgl@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Andrew Dunstan <andrew@dunslane.net>
Cc: pgsql-hackers@postgreSQL.org
Date: 2012-06-21T23:43:08Z
Lists: pgsql-hackers
Andrew Dunstan <andrew@dunslane.net> writes: > On 06/21/2012 06:25 PM, Tom Lane wrote: >> Hm, I guess I've forgotten that one? > See <http://archives.postgresql.org/pgsql-hackers/2012-01/msg00561.php> I didn't understand that then, and I still don't. The ALTER TABLE CLUSTER might need exclusive lock, but it's not going to hold the lock long enough to be an issue. I could see that there's a problem with identify_locking_dependencies believing that two CONSTRAINT items conflict (do they really?) but not convinced the CLUSTER aspect has anything to do with it. regards, tom lane