| From: | "yoursoft(at)freemail(dot)hu" <yoursoft(at)freemail(dot)hu> |
|---|---|
| To: | pgadmin-support(at)postgresql(dot)org |
| Subject: | BUG |
| Date: | 2004-10-21 20:11:07 |
| Message-ID: | 417817DB.4080606@freemail.hu |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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' / Action tab.
The 'On update' radio button group will be wrong value: 'RESTRICT' (
I think the good value is: 'SET DELETE').
Best Regards:
Ferenc
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gary Doades | 2004-10-21 21:06:02 | pgAdmin Beta 3 problems |
| Previous Message | Andreas Pflug | 2004-10-21 14:36:33 | Re: BUG |