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' / Action tab.
The 'On update' radio button group will be wrong value: 'RESTRICT' ( I think the good value is: 'SET DELETE').
Best Regards:
Ferenc---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
