Skip site navigation (1) Skip section navigation (2)

CREATE TABLE LIKE question

From: Robert Creager <Robert_Creager(at)LogicalChaos(dot)org>
To: PGSQL <pgsql-sql(at)postgresql(dot)org>
Subject: CREATE TABLE LIKE question
Date: 2004-03-19 15:26:25
Message-ID: 20040319082625.343461bb.Robert_Creager@LogicalChaos.org (view raw or flat)
Thread:
Lists: pgsql-sql
--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--



Attachment: unknown_filename
Description: multipart/signed (1.1 KB)

pgsql-sql by date

Next:From: Erik ThieleDate: 2004-03-19 15:27:58
Subject: Re: triggers on commit
Previous:From: Tom LaneDate: 2004-03-19 15:13:56
Subject: Re: triggers on commit

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group