Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgadmin-support by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group