Actually, this is what the spec defines. You're using match
unspecified, which means:
- If no was specified then, for each row R1 of the
referencing table, either at least one of the values of the
referencing columns in R1 shall be a null value, or the value of
each referencing colum
> -Original Message-
> From: Richard Ellis [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, September 06, 2000 1:00 PM
> To: [EMAIL PROTECTED]
> Subject: Re: [BUGS] Possible bug in referential integrity system
>
> > create table t1 (num int4, name text);
> &
I'm not sure what the supposed bug is...
> From: Alexei E Korneyev [mailto:[EMAIL PROTECTED]]
[ reformated by PS]
create table t1 (num int4 PRIMARY KEY, name text);
create table t2 (ref int4 references t1 (num) NOT NULL, val text);
insert into t1 values (1
Hello!
Keys phrase 'NOT NULL'
simple=# create table t1 (num int4 PRIMARY KEY, name text);
NOTICE: CREATE TABLE/PRIMARY KEY will create implicit index 't1_pkey' for
table 't1'
CREATE
simple=# create table t2 (ref int4 references t1 (num) NOT NULL, val text);
NOTICE: CREATE TABLE will create impl
