agora inbox for pgadmin-support@postgresql.org  

help / color / mirror / Atom feed

From: yoursoft@freemail.hu <yoursoft@freemail.hu>
To: pgadmin-support@postgresql.org
Subject: BUG
Date: Thu, 21 Oct 2004 22:11:07 +0200
Message-ID: <417817DB.4080606@freemail.hu> (raw)

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

view thread (30+ messages)  latest in thread

Message-ID: <417817DB.4080606@freemail.hu>
Permalink:  ../417817DB.4080606@freemail.hu/
Also on:    postgresql.org/message-id/417817DB.4080606@freemail.hu

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgadmin-support@postgresql.org
  Cc: yoursoft@freemail.hu
  Subject: Re: BUG
  In-Reply-To: <417817DB.4080606@freemail.hu>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox