[prev in list] [next in list] [prev in thread] [next in thread] 

List:       pgsql-bugs
Subject:    Re: BEFORE triggers that return NULL can circumvent referential integrity
From:       Jim Finnerty <jfinnert () amazon ! com>
Date:       2018-10-31 13:40:07
Message-ID: 1540993207811-0.post () n3 ! nabble ! com
[Download RAW message or body]

Thank you, Pavel.  The initial issue is the willingness to modify the RETURN
NULL semantics so that it causes a statement to fail if the triggering event
was a referential action, thereby preserving both Foreign Key semantics and
RETURN NULL semantics in cases other than when it breaks referential
integrity.  In my opinion, extending SQL in a way that broke referential
integrity was a mistake, but it's a mistake that can be fixed without too
much impact on existing applications.

If the community is willing to accept that RETURN NULL needs this tweak to
its semantics, we can provide an implementation and will post it to
pghackers.



-----
Jim Finnerty, AWS, Amazon Aurora PostgreSQL
--
Sent from: http://www.postgresql-archive.org/PostgreSQL-bugs-f2117394.html

[prev in list] [next in list] [prev in thread] [next in thread]