Re: Constraint or index or both?

Erwin Brandstetter wrote:
> 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);

No - simple thinko. Fixed in SVN, thanks.

Regards, Dave.