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.
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 |