Re: rename primary key

Le 15/01/2010 04:39, Seb a écrit :
> On Fri, 15 Jan 2010 12:34:15 +0900,
> Ian Barwick <barwick@gmail.com> wrote:
> [...]
> On a related note: how come pgadmin3 shows "Indexes (0)" for such a
> table, even though an index does exist for the primary key?  Are these
> indexes created in a separate table that is looked up by the foo table?
> 

Primary keys are constraints. They are enforced with an index, but
actually they are constraints. So we put them on the constraints nodes.

There is the same behaviour for unique constraints.


-- 
Guillaume.http://www.postgresqlfr.orghttp://dalibo.com