From: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
---|---|
To: | Patrice Lefebvre <plefebvre(at)ctecworld(dot)com> |
Cc: | pgadmin-support(at)postgresql(dot)org |
Subject: | Re: Editing table properties drops all foreign keys and recreates them |
Date: | 2012-09-23 13:50:23 |
Message-ID: | 1348408223.11977.9.camel@localhost.localdomain |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
On Fri, 2012-09-21 at 09:34 -0400, Patrice Lefebvre wrote:
> 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.
>
>
Yeah, I reproduce the issue. I added a ticket to work on this later.
--
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com
From | Date | Subject | |
---|---|---|---|
Next Message | Guillaume Lelarge | 2012-09-23 13:52:03 | Re: Graphical Query Builder bug |
Previous Message | Guillaume Lelarge | 2012-09-23 13:44:56 | Re: pgadmin3 crash |