Re: Deleting orphan records

Поиск
Список
Период
Сортировка
От John Smith
Тема Re: Deleting orphan records
Дата
Msg-id 20030206042700.26538.qmail@web40701.mail.yahoo.com
обсуждение исходный текст
Ответ на Re: Deleting orphan records  ("Chris Travers" <chris@travelamericas.com>)
Ответы Re: Deleting orphan records
Список pgsql-general
Дерево обсуждения

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 по дате отправления: