Postgres Pro
Downloads
Home   >   mailing lists

Re: Deleting orphan records - Mailing list pgsql-general

From Chris Travers
Subject Re: Deleting orphan records
Date
Msg-id 030901c2cd7a$59548250$4d733b9d@redmond.corp.microsoft.com
Whole thread Raw
In response to Deleting orphan records  (John Smith <john_smith_45678@yahoo.com>)
Responses Re: Deleting orphan records  (John Smith <john_smith_45678@yahoo.com>)
List pgsql-general
Tree view
Does ON DELETE CASCADE not work for you?
 
Other than that you would have do do outer join acrobatics ;-)
 
Best Regards;
Chris Travers
----- Original Message -----
Sent: Wednesday, February 05, 2003 12:55 PM
Subject: [GENERAL] Deleting orphan records

Does anybody have a method for deleting orphan (unreferenced) records? Is it possible to set up some sort of constraint or trigger (that performs well when lots of records are deleted ;) )?


Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now

pgsql-general by date:

Previous
From: Greg Stark
Date:
Subject: Re: not exactly a bug report, but surprising behaviour
Next
From: Bruno Wolff III
Date:
Subject: Re: databases limit