Postgres Pro
Downloads
Home   >   mailing lists

Re: Deleting orphan records - Mailing list pgsql-general

From John Smith
Subject Re: Deleting orphan records
Date
Msg-id 20030206042700.26538.qmail@web40701.mail.yahoo.com
Whole thread Raw
In response to Re: Deleting orphan records  ("Chris Travers" <chris@travelamericas.com>)
Responses Re: Deleting orphan records  ("Nigel J. Andrews" <nandrews@investsystems.co.uk>)
List pgsql-general
Tree view

I was referring to parent records with no children ;).

John

 Chris Travers <chris@travelamericas.com> wrote:

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


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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: not exactly a bug report, but surprising behaviour
Next
From: jerome
Date:
Subject: Backup scheme...