X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id C16C1D1C4EC for ; Fri, 19 Mar 2004 15:27:26 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 44716-06 for ; Fri, 19 Mar 2004 11:27:19 -0400 (AST) Received: from srvr3.iniquinet.com (srvr2.iniquinet.com [64.240.87.12]) by svr1.postgresql.org (Postfix) with SMTP id 87AECD1EBF8 for ; Fri, 19 Mar 2004 11:27:09 -0400 (AST) Received: (qmail 29912 invoked by uid 104); 19 Mar 2004 15:06:35 -0000 Received: from Robert_Creager@LogicalChaos.org by srvr3.iniquinet.com by uid 101 with qmail-scanner-1.15 (clamscan: 0.65. spamassassin: 2.55. Clear:SA:0(-6.8/6.0):. Processed in 31.910107 secs); 19 Mar 2004 15:06:35 -0000 Received: from unknown (HELO thunder.mshome.net) (216.58.165.145) by srvr3.iniquinet.com with SMTP; 19 Mar 2004 15:06:03 -0000 Received: from localhost.localdomain (thunder.mshome.net [192.168.0.250]) by thunder.mshome.net (Postfix) with ESMTP id E88B1CA746 for ; Fri, 19 Mar 2004 08:26:35 -0700 (MST) Received: from logicalchaos.org (thunder.mshome.net [192.168.0.250]) by thunder.mshome.net (Postfix) with SMTP id 9AFAECA722 for ; Fri, 19 Mar 2004 08:26:25 -0700 (MST) Date: Fri, 19 Mar 2004 08:26:25 -0700 From: Robert Creager To: PGSQL Subject: CREATE TABLE LIKE question Message-Id: <20040319082625.343461bb.Robert_Creager@LogicalChaos.org> Organization: Starlight Vision, LLC. X-Mailer: Sylpheed version 0.9.5claws (GTK+ 1.2.10; i586-mandrake-linux-gnu) Mime-Version: 1.0 Content-Type: multipart/signed; protocol="application/pgp-signature"; micalg="pgp-sha1"; boundary="Multipart_Fri__19_Mar_2004_08_26_25_-0700_=.H?b.ulSyXSei6f" UPPERCASE_25_50,USER_IN_WHITELIST autolearn=no version=2.63 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/208 X-Sequence-Number: 17307 --Multipart_Fri__19_Mar_2004_08_26_25_-0700_=.H?b.ulSyXSei6f Content-Type: text/plain; charset=US-ASCII Content-Disposition: inline Content-Transfer-Encoding: 7bit Hey Folks, I'm doing the following, and the primary key/index are not being transfered to the new table. Is this too much to ask for, or a bug? CREATE SCHEMA minute; CREATE TABLE minute.barometer ( "time" TIMESTAMP NOT NULL, time_group INTEGER PRIMARY KEY, min_reading FLOAT NOT NULL, max_reading FLOAT NOT NULL, avg_reading FLOAT NOT NULL ); CREATE TABLE minute.insidetemp ( LIKE minute.barometer INCLUDING DEFAULTS ); Thanks, Rob -- 08:22:09 up 8 days, 11:33, 2 users, load average: 2.51, 2.33, 2.17 Linux 2.4.21-0.13_test #60 SMP Sun Dec 7 17:00:02 MST 2003 --Multipart_Fri__19_Mar_2004_08_26_25_-0700_=.H?b.ulSyXSei6f Content-Type: application/pgp-signature -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.3 (GNU/Linux) iEYEARECAAYFAkBbESEACgkQLQ/DKuwDYznWdQCeNuG0lOJ5j8WsADdSbUjkAIqA sdwAnRyDX5cg8+7W/7Vltqs8bg+dDPj6 =lPtC -----END PGP SIGNATURE----- --Multipart_Fri__19_Mar_2004_08_26_25_-0700_=.H?b.ulSyXSei6f--