Re: Deleting orphan records - Mailing list pgsql-general

From Jan Wieck
Subject Re: Deleting orphan records
Date
Msg-id 3E491469.AB4B5EDF@Yahoo.com
Whole thread Raw
In response to Re: Deleting orphan records  (John Smith <john_smith_45678@yahoo.com>)
Responses Re: Deleting orphan records  (John Smith <john_smith_45678@yahoo.com>)
List pgsql-general
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 #

pgsql-general by date:

Previous
From: Viacheslav N Tararin
Date:
Subject: Rights for view.
Next
From: Tom Lane
Date:
Subject: Re: Priority against catalog