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