RE: [SQL] rename table - primary key index?

From: "Jackson, DeJuan" <djackson(at)cpsgroup(dot)com>
To: Leslie Mikesell <les(at)Mcs(dot)Net>, pgsql-sql(at)postgreSQL(dot)org
Subject: RE: [SQL] rename table - primary key index?
Date: 1998-09-03 18:29:28
Message-ID: F10BB1FAF801D111829B0060971D839F3E2D21@cpsmail
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)mcs(dot)com

Browse pgsql-sql by date

  From Date Subject
Next Message Jackson, DeJuan 1998-09-03 18:45:54 RE: Resp: [SQL] Concatenation in selects
Previous Message Fidelis Assis 1998-09-03 17:54:25 Resp: RE: Resp: [SQL] Concatenation in selects