Le 15/01/2010 17:13, Seb a écrit :
> On Fri, 15 Jan 2010 07:35:17 +0100,
> Guillaume Lelarge 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 fo
On Fri, 15 Jan 2010 07:35:17 +0100,
Guillaume Lelarge 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
Le 15/01/2010 04:39, Seb a écrit :
> On Fri, 15 Jan 2010 12:34:15 +0900,
> Ian Barwick 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
On Fri, 15 Jan 2010 12:34:15 +0900,
Ian Barwick wrote:
[...]
> Is this what you mean?
[...]
Exactly! Thanks.
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
2010/1/15 Seb :
> Hi,
>
> Is it possible to rename a primary key? I learnt that to rename foreign
> keys one has to drop it and recreate with the new name, or add a new new
> and drop the old one. What is the approach for primary keys? Thanks.
Is this what you mean?
psql (8.4.2)
You are now c
Hi,
Is it possible to rename a primary key? I learnt that to rename foreign
keys one has to drop it and recreate with the new name, or add a new new
and drop the old one. What is the approach for primary keys? Thanks.
Cheers,
--
Seb
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresq
