pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
rename table - primary key index?
2+ messages / 2 participants
[nested] [flat]

* rename table - primary key index?
@ 1998-09-01 17:24  Leslie Mikesell <les@Mcs.Net>
  0 siblings, 0 replies; 2+ messages in thread

From: Leslie Mikesell @ 1998-09-01 17:24 UTC (permalink / raw)
  To: 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?

  Les Mikesell
   les@mcs.com



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* RE: [SQL] rename table - primary key index?
@ 1998-09-03 18:29  Jackson, DeJuan <djackson@cpsgroup.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Jackson, DeJuan @ 1998-09-03 18:29 UTC (permalink / raw)
  To: Leslie Mikesell <les@Mcs.Net>; 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



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~1998-09-03 18:29 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1998-09-01 17:24 rename table - primary key index? Leslie Mikesell <les@Mcs.Net>
1998-09-03 18:29 RE: [SQL] rename table - primary key index? Jackson, DeJuan <djackson@cpsgroup.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox