X-Original-To: pgadmin-support-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 926A132B155 for ; Thu, 21 Oct 2004 15:11:15 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 28331-02 for ; Thu, 21 Oct 2004 14:11:03 +0000 (GMT) Received: from matav-3.matav.hu (matav-3.matav.hu [145.236.252.34]) by svr1.postgresql.org (Postfix) with ESMTP id DA48332B139 for ; Thu, 21 Oct 2004 15:11:01 +0100 (BST) Received: by matav-3.matav.hu with esmtp; Thu, 21 Oct 2004 16:11:01 +0200 Message-ID: <417817DB.4080606@freemail.hu> Date: Thu, 21 Oct 2004 22:11:07 +0200 From: "yoursoft@freemail.hu" User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; hu-HU; rv:1.7.2) Gecko/20040803 X-Accept-Language: hu MIME-Version: 1.0 To: pgadmin-support@postgresql.org Subject: BUG Content-Type: text/plain; charset=ISO-8859-2; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=2.2 tagged_above=0.0 required=5.0 tests=DATE_IN_FUTURE_06_12, UPPERCASE_25_50 X-Spam-Level: ** X-Archive-Number: 200410/138 X-Sequence-Number: 3614 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