Re: Deleting orphan records - Mailing list pgsql-general

From John Smith
Subject Re: Deleting orphan records
Date
Msg-id 20030211211355.85986.qmail@web40712.mail.yahoo.com
Whole thread Raw
In response to Re: Deleting orphan records  (Jan Wieck <JanWieck@Yahoo.com>)
List pgsql-general

Are there plans to implement PENDANT?

http://www.ca.postgresql.org/projects/devel-refint.html
http://www.dbazine.com/mullins_triggers.html
http://developer.postgresql.org/cvsweb.cgi/pgsql-server/doc/TODO.detail/foreign.diff?r1=1.1&r2=1.2

Sorry about the MIME emails - can't figure out how to get Yahoo to send text (I see you use Yahoo - how's it done? ;) ).

John

Jan Wieck <JanWieck@Yahoo.com> wrote:

John Smith wrote:
> I was referring to parent records with no children ;).
>
> John

I think this sort of reference requirement is meant by the SQL keyword
PENDANT. Not sure what PENDANT ON DELETE CASCADE then is supposed to do,
but removing parents that became childless would be one plausible
interpretation.

PENDANT is not yet implemented in PostgreSQL.

And please, John, can you stop sending your plain text messages as
multipart mime encoded?


Jan

--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck@Yahoo.com #



Do you Yahoo!?
Yahoo! Shopping - Send Flowers for Valentine's Day

pgsql-general by date:

Previous
From: "Cristian Custodio"
Date:
Subject: Fw: Priority against catalog
Next
From: Bruce Momjian
Date:
Subject: Report on Japan, Belgium trip