serial and namespace - Mailing list pgsql-hackers

From Hiroshi Inoue
Subject serial and namespace
Date
Msg-id 3CA9361D.5D452A76@tpf.co.jp
Whole thread Raw
Responses Re: serial and namespace  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Hi,

I created a schema *inoue* and tried the following.
 # create table inoue.t1 (id serial primary key, dt text); NOTICE:  CREATE TABLE will create implicit sequence
't1_id_seq'for SERIAL column 't1.id' NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 't1_pkey' for table
't1'CREATE # insert into inoue.t1 (dt) values ('abc'); ERROR:  Relation "t1_id_seq" does not exist
 

regards,
Hiroshi Inoue


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: inserting user defined types through a rule?
Next
From: Bear Giles
Date:
Subject: Re: inserting user defined types through a rule?