From: | "pgAdmin Trac" <trac(at)code(dot)pgadmin(dot)org> |
---|---|
To: | |
Cc: | pgadmin-hackers(at)postgresql(dot)org |
Subject: | [pgAdmin III] #378: Editing table properties drops all foreign keys and recreates them |
Date: | 2012-09-23 13:50:19 |
Message-ID: | 057.490346f9d9845afd3054f057e8421e86@code.pgadmin.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-hackers |
#378: Editing table properties drops all foreign keys and recreates them
------------------------------+---------------------------------------------
Reporter: Patrice Lefebvre | Owner: dpage
Type: bug | Status: new
Priority: minor | Milestone:
Component: pgadmin | Version: trunk
Keywords: foreignkeys | Platform: all
------------------------------+---------------------------------------------
When I open the properties on a table containing foreign key constraints,
and then to go the SQL tab to see what will be executed, I notice all
foreign keys are dropped and then recreated. For example when I open the
table properties for the table zulook.inv_equipment on my database, the
SQL pane reads as follow:
ALTER TABLE zulook.inv_equipment
DROP CONSTRAINT inv_equipment_company_entity_id_fkey;
ALTER TABLE zulook.inv_equipment
DROP CONSTRAINT inv_equipment_item_id_fkey;
ALTER TABLE zulook.inv_equipment
ADD CONSTRAINT inv_equipment_company_entity_id_fkey FOREIGN KEY
(company_entity_id)
REFERENCES zulook.ab_company (company_entity_id) MATCH SIMPLE
ON UPDATE NO ACTION ON DELETE NO ACTION DEFERRABLE INITIALLY
IMMEDIATE;
ALTER TABLE zulook.inv_equipment
ADD CONSTRAINT inv_equipment_item_id_fkey FOREIGN KEY (item_id)
REFERENCES zulook.inv_item (item_id) MATCH SIMPLE
ON UPDATE NO ACTION ON DELETE NO ACTION DEFERRABLE INITIALLY
IMMEDIATE;
I didn't have this behaviour problem under 1.12.x versions, I've noticed
it starting with 1.14.x versions, and now it is still present in 1.16.0. I
use pgAdmin 1.16.0 (Sep 7 2012, rev: REL-1_16_0, from binary) under
Windows XP SP3, English version but on a Canadian French OS.
--
Ticket URL: <http://code.pgadmin.org/trac/ticket/378>
pgAdmin III <http://code.pgadmin.org/trac/>
pgAdmin III
From | Date | Subject | |
---|---|---|---|
Next Message | pgAdmin Trac | 2012-09-23 13:51:41 | [pgAdmin III] #379: Graphical Query Builder bug |
Previous Message | Dave Page | 2012-09-23 11:34:31 | Re: Information for added functionalities |