Re: [SQL] [NOVICE] SET CONSTRAINTS question...

2002-07-22 Thread Stephan Szabo
> 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

[SQL] [NOVICE] SET CONSTRAINTS question...

2002-07-22 Thread Michael Paesold
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