Re: Deleting orphan records

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(at)Yahoo(dot)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(at)Yahoo(dot)com #

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