BUG - Mailing list pgadmin-support

From yoursoft@freemail.hu
Subject BUG
Date
Msg-id 417817DB.4080606@freemail.hu
Whole thread Raw
Responses Re: BUG  (Andreas Pflug <pgadmin@pse-consulting.de>)
List pgadmin-support
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


pgadmin-support by date:

Previous
From: "Ben Trewern"
Date:
Subject: Adding Not Null constraints doesn't work with beta 3
Next
From: Andreas Pflug
Date:
Subject: Re: BUG