Thread: Comment on table forces recreation of constraints

Comment on table forces recreation of constraints

From
Bartosz Dmytrak
Date:
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