FROM ONLY limitation in RICs

From: James Pye <jwp(at)rhid(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: FROM ONLY limitation in RICs
Date: 2003-06-07 18:17:03
Message-ID: 20030607181703.GA436@void.ph.cox.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


Does the SQL(99?) spec specify that referential integrity checks should have the FROM ONLY limitation? I ask because(afiak; I've googled and such, only found 92 which apparently does not specify anything about inheritance.) I have no access to the specs without spending money that needs to go other places..

I have a hierarchy of tables that reference base tables that may never have insertions, but its children do, which of course creates the problem of "broken" referential integrity checks due to FROM ONLY.

Of course I know I can edit the source, but I figured I'd see if this is specified in the spec, and hopefully induce a change if it isn't.

Thanks for you time,

James

btw, I'm not on the list(yet, perhaps), so please CC me.

Browse pgsql-hackers by date

  From Date Subject
Next Message Larry Rosenman 2003-06-07 19:41:50 7.3.3 COMPILE FAILURE: pg_dump
Previous Message ohp 2003-06-07 18:04:28 security flaw