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

[PATCH] Support for ALTER TABLE ADD UNIQUE/PKEY USING INDEX

From: BillR <iambill(at)williamrosmus(dot)com>
To: pgadmin-hackers(at)postgresql(dot)org
Subject: [PATCH] Support for ALTER TABLE ADD UNIQUE/PKEY USING INDEX
Date: 2012-03-15 02:46:30
Message-ID: 4F615806.70804@williamrosmus.com (view raw or flat)
Thread:
Lists: pgadmin-hackers
This may be a little late, but according to the postgres documentation, 
isn't an index supposed to be created automatically by postgres when you 
create a unique or primary key constraint? So isn't this redundant. Note 
that I am not sure because I created a unique constraint in an 8.4 db 
using pgadmin *and* via DDL in the sql editor, and an index did not 
appear to be created; counter to what the docs say is supposed to 
happen. I'd be interested to hear someone's take on this.

http://www.postgresql.org/docs/9.1/interactive/ddl-constraints.html#AEN2470

Regards,

BillR

Responses

pgadmin-hackers by date

Next:From: Guillaume LelargeDate: 2012-03-15 07:14:35
Subject: Re: [PATCH] Support for ALTER TABLE ADD UNIQUE/PKEY USING INDEX
Previous:From: Guillaume LelargeDate: 2012-03-14 20:07:23
Subject: Re: pgAdmin 1.15 experiences

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