RE: [SQL] rename table - primary key index? - Mailing list pgsql-sql

From Jackson, DeJuan
Subject RE: [SQL] rename table - primary key index?
Date
Msg-id F10BB1FAF801D111829B0060971D839F3E2D21@cpsmail
Whole thread Raw
List pgsql-sql
> Shouldn't:
>  alter table xxx rename to yyy
> also adjust the index built as a side effect of 'primary key'
> in the create table operation?
As far as v6.3.2 is concerned a primary key definition is simply a
unique index.  After the table is created there is no method to
determine which index was declared using as primary key.
        -DEJ

>   Les Mikesell
>    les@mcs.com

pgsql-sql by date:

Previous
From: "Fidelis Assis"
Date:
Subject: Resp: [SQL] Concatenation in selects
Next
From: "Jackson, DeJuan"
Date:
Subject: RE: Resp: [SQL] Concatenation in selects