| From: | John Smith <john_smith_45678(at)yahoo(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Deleting orphan records |
| Date: | 2003-02-06 04:27:00 |
| Message-ID: | 20030206042700.26538.qmail@web40701.mail.yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
I was referring to parent records with no children ;).
John
Chris Travers <chris(at)travelamericas(dot)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 ----- From: John Smith To: pgsql-general(at)postgresql(dot)org Sent: Wednesday, February 05, 2003 12:55 PMSubject: [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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Greg Stark | 2003-02-06 04:44:50 | Re: not exactly a bug report, but surprising behaviour |
| Previous Message | Tom Lane | 2003-02-06 03:40:05 | Re: not exactly a bug report, but surprising behaviour |