Skip site navigation (1) Skip section navigation (2)

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 (view raw, whole thread or download thread mbox)
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.

>   Les Mikesell
>    les(at)mcs(dot)com

pgsql-sql by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group