> On 03 Jan 2015, at 14:11, Alban Hertroys <haram...@gmail.com> wrote: > > On 02 Jan 2015, at 13:31, Rafal Pietrak <ra...@ztk-rp.eu> wrote: >> Would it violate SQL standard (signifficantly), if an "on delete set null" >> action just ignored all the FK columns that have a "NOT NULL" constraint set? > > As I understand it, this is precisely why Boyce-relationality forbids NULLs > in primary keys, although I’m not so sure he’s right about that.
Well, that’s embarrassing, it’s only a few weeks since I learned this and I’m already attributing the theory to the wrong database deity! That’s Codd-relationality, of course. Not Boyce. Alban Hertroys -- If you can't see the forest for the trees, cut the trees and you'll find there is no forest. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
