From: | t-ishii(at)sra(dot)co(dot)jp (Tatsuo Ishii) |
---|---|
To: | pgsql-hackers(at)postgreSQL(dot)org |
Subject: | SERIAL data type |
Date: | 1998-09-12 01:23:55 |
Message-ID: | 199809120125.KAA05600@meshsv26.tk.mesh.ad.jp |
Views: | Whole Thread | Raw Message | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
A few questions for new SERIAL data type:
o dropping a table including a serial data type does not drop the sequence
corresponding to the table. This prevents re-creating the table.
Do we have to remove the sequence by hand?
o explicit insertion to the serial column sets the value specified.
This is good. However, next implicit insertion results in that
previous value from the sequence + 1 is set.
create table t (c text, i serial);
insert into t values('a');
insert into t values('b',100);
insert into tvalues('c');
select * from t;
a 1
b 100
c 2
This seems a little bit unnatural for me. may be i of the thrid row
should be 101?
--
Tatsuo Ishii
t-ishii(at)sra(dot)co(dot)jp
From | Date | Subject | |
---|---|---|---|
Next Message | D'Arcy J.M. Cain | 1998-09-12 02:11:31 | Re: [HACKERS] Serial Data Type |
Previous Message | Tatsuo Ishii | 1998-09-12 01:23:53 | Re: pgrewrite: was Re: [HACKERS] pg_user problem |