Constraint or index or both?

From: Erwin Brandstetter <brandstetter(at)falter(dot)at>
To: pgadmin-support(at)postgresql(dot)org
Subject: Constraint or index or both?
Date: 2006-11-27 16:45:24
Message-ID: 456B1624.5030903@falter.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message novnov 2006-11-27 16:50:49 Can tables have calculated columns?
Previous Message Markus Schaber 2006-11-27 13:48:06 Re: [SQL] PgAgent [where is it?]