From: Robert Creager <Robert_Creager@LogicalChaos.org>
To: PGSQL <pgsql-sql@postgresql.org>
Subject: CREATE TABLE LIKE question
Date: Fri, 19 Mar 2004 08:26:25 -0700
Message-ID: <20040319082625.343461bb.Robert_Creager@LogicalChaos.org> (raw)
--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--
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: Robert_Creager@LogicalChaos.org
Subject: Re: CREATE TABLE LIKE question
In-Reply-To: <20040319082625.343461bb.Robert_Creager@LogicalChaos.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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