Comment on table forces recreation of constraints - Mailing list pgadmin-support

From Bartosz Dmytrak
Subject Comment on table forces recreation of constraints
Date
Msg-id CAD8_UcYx5GZPHTneFkcN1UoGiMtvd_owQV_MzcipvR6JnGaoQw@mail.gmail.com
Whole thread Raw
List pgadmin-support
Hi all,
here is strange thing I found:
When I try to create a comment on my table, pgAdmin script generated behind the scene recreates constraints (primary key and foreign keys). It simply add ALTER TABLE ... DROP CONSTRAINT ... and ALTER TABLE ... ADD CONSTRAINT - this is not needed.

COMMENT ON TABLE ... is added at the end of the script too.

Another odd thing is refreshing object explorer on changes of object defs (via GUI). All schema nodes are collapsed and edited object is not visible any more eg. when you put a comment on column. This is very annoying when db contains many objects.

Env.
pgAdmin 1.16.1 on Windows.


Regards,
Bartek

pgadmin-support by date:

Previous
From: Guillaume Lelarge
Date:
Subject: Re: Date column types
Next
From: Farley Carter
Date:
Subject: Re: Date column types