Thread: CREATE TABLE LIKE question

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