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

Re: Constraint or index or both?

From: Dave Page <dpage(at)postgresql(dot)org>
To: Erwin Brandstetter <brandstetter(at)falter(dot)at>
Cc: pgadmin-support(at)postgresql(dot)org
Subject: Re: Constraint or index or both?
Date: 2006-11-28 09:37:02
Message-ID: 456C033E.6020704@postgresql.org (view raw or flat)
Thread:
Lists: pgadmin-support
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.

In response to

pgadmin-support by date

Next:From: Dave PageDate: 2006-11-28 10:35:24
Subject: Re: Treatment of views with associated rules -
Previous:From: Ben TrewernDate: 2006-11-27 17:18:56
Subject: Treatment of views with associated rules - Feature Request

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