Didn't know if this is a known issue or not, but I think the following ought to fail, and it does not:
mschout=# create table foo (f1 int not null, primary key (f1));
NOTICE: CREATE TABLE/PRIMARY KEY will create implicit index 'foo_pkey' for table 'foo'
so far, so good.
now the problem:
create table bar (
f2 int not null,
foreign key (blah) REFERENCES foo (f1) ON DELETE RESTRICT
I think this *should* fail since "blah" isn't defined in the table anywhere.
NOTICE: CREATE TABLE will create implicit trigger(s) for FOREIGN KEY check(s)
Note that column "blah" doesnt actually exist. Shouldn't we complain and bail
out from the create in this case? A typeo in a FOREIGN KEY clause would bypass
the restriction altogether.
The only reason I can think where this might be desired is if the table created
INHERITS some other table (that might have column "blah" in it). Maybe there
is some easy way to check that though?
This is on postgreSQL 7.0.2, Redhat Linux 6.2
Anyways, figured I better report this in case its not a known issue :)
pgsql-hackers by date
|Next:||From: Michael J Schout||Date: 2000-07-28 00:10:04|
|Subject: Possible bug in FOREIGN KEY|
|Previous:||From: Joe Brenner||Date: 2000-07-27 20:44:52|
|Subject: Re: Inprise InterBase(R) 6.0 Now Free and Open Source |