Received: from bjke.com (firewall-user@ganymede.bjke.com [144.210.8.38]) by hub.org (8.8.8/8.7.5) with ESMTP id OAA14225 for ; Thu, 3 Sep 1998 14:28:27 -0400 (EDT) Received: by bjke.com; id NAA02484; Thu, 3 Sep 1998 13:28:20 -0500 (CDT) Received: from cpsmail.cpsgroup.com(144.210.12.11) by gauntlet.bjke.com via smap (4.1) id xmaa02079; Thu, 3 Sep 98 13:27:56 -0500 Received: by cpsmail with Internet Mail Service (5.0.1458.49) id ; Thu, 3 Sep 1998 13:29:30 -0500 Message-ID: From: "Jackson, DeJuan" To: Leslie Mikesell , pgsql-sql@postgreSQL.org Subject: RE: [SQL] rename table - primary key index? Date: Thu, 3 Sep 1998 13:29:28 -0500 X-Priority: 3 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.0.1458.49) Content-Type: text/plain > 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