It seems like 3 vs 1 so you win :) I'll drop the constraint and verify the integrity of the new records manually
tanks > > On Thu, Jul 17, 2008 at 10:52 AM, Douglas McNaught wrote: >> On Thu, Jul 17, 2008 at 12:11 PM, Ismael .... wrote: >>> >>> hi >>> I have one of those master-detail relationships here and I need to be able >>> to delete the master but leave the details untouched >> >> Then remove the referential integrity constraint, since it's obviously >> incompatible with your business requirements. > > Generally I'd agree, but it might be useful to set the child record > referencing id field to NULL in this circumstance. _________________________________________________________________ Tenemos lo que búscas…JUEGOS. http://club.prodigymsn.com/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
