On Thu, Jul 17, 2008 at 10:52 AM, Douglas McNaught <[EMAIL PROTECTED]> wrote: > On Thu, Jul 17, 2008 at 12:11 PM, Ismael .... <[EMAIL PROTECTED]> 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. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general