ERROR: UNIQUE constraint ... not found?
От | Ed L. |
---|---|
Тема | ERROR: UNIQUE constraint ... not found? |
Дата | |
Msg-id | 200304021531.07990.pgsql@bluepolka.net обсуждение исходный текст |
Ответы |
Re: ERROR: UNIQUE constraint ... not found?
Re: ERROR: UNIQUE constraint ... not found? Re: ERROR: UNIQUE constraint ... not found? |
Список | 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
В списке pgsql-general по дате отправления: