Postgres Pro
Downloads
Home   >   mailing lists

SELECT blocking on ALTER TABLE ADD FOREIGN KEY - Mailing list pgsql-hackers

From Jim C. Nasby
Subject SELECT blocking on ALTER TABLE ADD FOREIGN KEY
Date
Msg-id 20030611183908.GN40542@flake.decibel.org
Whole thread Raw
Responses Re: SELECT blocking on ALTER TABLE ADD FOREIGN KEY  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tree view 
Is it really necessary to block reads on a table that is affected by
adding a foreign key constraint? I can see why you wouldn't want UPDATES
or INSERTS on the child table or DELETEs on the parent, but select
should be fine on both tables, no?
-- 
Jim C. Nasby (aka Decibel!)                    jim@nasby.net
Member: Triangle Fraternity, Sports Car Club of America
Give your computer some brain candy! www.distributed.net Team #1828

Windows: "Where do you want to go today?"
Linux: "Where do you want to go tomorrow?"
FreeBSD: "Are you guys coming, or what?"

pgsql-hackers by date:

Previous
From: Forest Wilkinson
Date:
Subject: Re: [GENERAL] How to enumerate foreign key constraints after migrating from 7.1.3?
Next
From: Bruce Momjian
Date:
Subject: Re: Please, apply patch for current CVS