Skip site navigation (1) Skip section navigation (2)

BUG

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 (view raw or flat)
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

Responses

  • Re: BUG at 2004-10-21 14:36:33 from Andreas Pflug

pgadmin-support by date

Next:From: Gary DoadesDate: 2004-10-21 21:06:02
Subject: pgAdmin Beta 3 problems
Previous:From: Andreas PflugDate: 2004-10-21 14:36:33
Subject: Re: BUG

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group