Re: rename primary key

From: Seb <spluque(at)gmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: rename primary key
Date: 2010-01-15 16:13:51
Message-ID: 87eilrz6ps.fsf@kolob.sebmags.homelinux.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Fri, 15 Jan 2010 07:35:17 +0100,
Guillaume Lelarge <guillaume(at)lelarge(dot)info> wrote:

[...]

> 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.

Thanks. Would there be any problem with listing the index used to
enforce the primary key constraint in the Indexes node to let us know of
its existence? In fact, psql does report it with the meta-command \d.
It was somewhat confusing to see Indexes(0), and then having to rename
an index to rename a primary key constraint.

--
Seb

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Chris 2010-01-17 21:59:56 Re: indexes
Previous Message Seb 2010-01-15 16:04:56 indexes