Обсуждение: 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