Dear List!
My Platform is: WinXp
My versions: All Binary Snapsots to 20041016; Version 1.1
Try the following:
1.
create tables:
CREATE TABLE ytable
( kod varchar(30) NOT NULL
);
CREATE TABLE xtable
( kod varchar(30) NOT NULL
);
An fk key definition:
ALTER TABLE xtable ADD CONSTRAINT cvbcbvc FOREIGN KEY (kod) REFERENCES ytable (kod) ON
UPDATE DEFAULT ON DELETE SET NULL;
2. View it in pgAdmin: Browse in left object tree to the 'xtable' / Constarins / 'cvbcbvc'. Select 'Properties' /
Actiontab. The 'On update' radio button group will be wrong value: 'RESTRICT' (
I think the good value is: 'SET DELETE').
Best Regards: Ferenc