Constraint or index or both? - Mailing list pgadmin-support

From Erwin Brandstetter
Subject Constraint or index or both?
Date
Msg-id 456B1624.5030903@falter.at
Whole thread Raw
Responses Re: Constraint or index or both?  (Dave Page <dpage@postgresql.org>)
List pgadmin-support
Hi developers! Hi Dave!

Testing 1.6.1 rev: 5646:5664M, client Win XP. Host Debian Sarge, PG 8.1.4

I noticed that primary key and unique constraints (both create an index) 
are listed twice in the object tree, under "Indexes" and "Constraints".
In 1.4.3 those were only listed under "Constraints". I think you changed 
it when fixing the refresh.
It makes sense in a way, but is it on purpose?

ALTER TABLE test ADD CONSTRAINT test_pkey PRIMARY KEY(test_id);
ALTER TABLE test ADD CONSTRAINT test_uni_idx UNIQUE(x, y);

Regards
Erwin


pgadmin-support by date:

Previous
From: novnov
Date:
Subject: Can tables have calculated columns?
Next
From: novnov
Date:
Subject: Upgrading pgAdmin III from 1.4.2 to 1.6.0 on Windows