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

[pgAdmin III] #378: Editing table properties drops all foreign keys and recreates them

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

Responses

pgadmin-hackers by date

Next:From: pgAdmin TracDate: 2012-09-23 13:51:41
Subject: [pgAdmin III] #379: Graphical Query Builder bug
Previous:From: Dave PageDate: 2012-09-23 11:34:31
Subject: Re: Information for added functionalities

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