Re: protected ON DELETE CASCADE - Mailing list pgsql-general

From Gregory Wood
Subject Re: protected ON DELETE CASCADE
Date
Msg-id 003301c12be2$a72afc60$7889ffcc@comstock.com
Whole thread Raw
In response to Re: protected ON DELETE CASCADE  (Jan Wieck <JanWieck@Yahoo.com>)
List pgsql-general
>     key  constraint  is  ON  DELETE  NO ACTION, which confusingly
>     enough aborts the transaction (it's defined that way  in  the
>     SQL  standard,  don't  ask  me why they called it NO ACTION).

NO ACTION because it takes no action on the child record? Makes sense when
you consider that otherwise you either CASCADE the delete to the child or
SET NULL for the child.

Greg


pgsql-general by date:

Previous
From: Jan Wieck
Date:
Subject: Re: protected ON DELETE CASCADE
Next
From: Jan Wieck
Date:
Subject: Re: SELECT FOR UPDATE