Deleting orphan records

From: John Smith <john_smith_45678(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Deleting orphan records
Date: 2003-02-05 20:55:12
Message-ID: 20030205205512.52156.qmail@web40712.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John Smith 2003-02-05 21:02:53 IN() alternatives
Previous Message Tom Lane 2003-02-05 20:49:52 Re: Crash Backend in 7.3.1