Received: from Kitten.mcs.com (Kitten.mcs.com [192.160.127.90]) by hub.org (8.8.8/8.7.5) with ESMTP id NAA22895 for ; Tue, 1 Sep 1998 13:24:39 -0400 (EDT) Received: from Venus.mcs.net (les@Venus.mcs.net [192.160.127.92]) by Kitten.mcs.com (8.8.7/8.8.2) with ESMTP id MAA03498 for ; Tue, 1 Sep 1998 12:24:34 -0500 (CDT) Received: (from les@localhost) by Venus.mcs.net (8.8.7/8.8.2) id MAA02926 for pgsql-sql@postgreSQL.org; Tue, 1 Sep 1998 12:24:33 -0500 (CDT) From: Leslie Mikesell Message-Id: <199809011724.MAA02926@Venus.mcs.net> Subject: rename table - primary key index? To: pgsql-sql@postgreSQL.org Date: Tue, 1 Sep 1998 12:24:33 -0500 (CDT) X-Mailer: ELM [version 2.4 PL24] Content-Type: text 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