serial and namespace

From: Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp>
To: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: serial and namespace
Date: 2002-04-02 04:39:57
Message-ID: 3CA9361D.5D452A76@tpf.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2002-04-02 06:37:51 Re: serial and namespace
Previous Message Bear Giles 2002-04-02 03:37:34 Re: inserting user defined types through a rule?