> CREATE SEQUENCE conn_id_seq;
> CREATE TABLE conn (
> id INTEGER NOT NULL DEFAULT nextval('conn_id_seq'),
> name VARCHAR(40),
> CONSTRAINT conn_friend_fkey FOREIGN KEY(name)
>REFERENCES friend(name)
>ON UPDATE CASCADE
>ON DELETE RESTRICT
I believe we interpreted restrict as being
Hi,
Right after installting postgres 7.2.1 (from release source) and reading
some chapters of Bruce Momjian's great book I started to play around with a
test database. Now I have a question concerning deferred constraint
checking.
I am new to transactional SQL, so I don't really know, if this sho