From: | "Ed L(dot)" <pgsql(at)bluepolka(dot)net> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | ERROR: UNIQUE constraint ... not found? |
Date: | 2003-04-02 22:31:07 |
Message-ID: | 200304021531.07990.pgsql@bluepolka.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Well, I've stared at this little riddle for long enough. Anyone see a
mistake?
$ cat test.sql
SELECT version();
CREATE TABLE person (
id SERIAL,
name VARCHAR NOT NULL
);
CREATE TABLE session (
id SERIAL,
person_id INTEGER NOT NULL,
FOREIGN KEY (person_id) REFERENCES person (id)
);
$ dropdb drilldb; createdb drilldb; psql -e -d drilldb -f test.sql
DROP DATABASE
CREATE DATABASE
SELECT version();
version
---------------------------------------------------------------------------------------------------------
PostgreSQL 7.3.2 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2
20020903 (Red Hat Linux 8.0 3.2-7)
(1 row)
CREATE TABLE person (
id SERIAL,
name VARCHAR NOT NULL
);
psql:test.sql:6: NOTICE: CREATE TABLE will create implicit sequence
'person_id_seq' for SERIAL column 'person.id'
CREATE TABLE
CREATE TABLE session (
id SERIAL,
person_id INTEGER NOT NULL,
FOREIGN KEY (person_id) REFERENCES person (id)
);
psql:test.sql:12: NOTICE: CREATE TABLE will create implicit sequence
'session_id_seq' for SERIAL column 'session.id'
psql:test.sql:12: NOTICE: CREATE TABLE will create implicit trigger(s) for
FOREIGN KEY check(s)
psql:test.sql:12: ERROR: UNIQUE constraint matching given keys for
referenced table "person" not found
From | Date | Subject | |
---|---|---|---|
Next Message | Ed L. | 2003-04-02 22:36:24 | Re: ERROR: UNIQUE constraint ... not found? |
Previous Message | scott.marlowe | 2003-04-02 22:20:23 | Re: Backend often crashing |