Hi!
I would like to add an entry to PostgreSQL 8.2 TODO:
- Extend SERIAL to a full-featured auto-incrementer type.
To achieve this, the following three requirements should be fulfilled:
1. The statement parser should be able to handle this:
create table x ( id serial(N), ...
);
and behind the scenes this would translate into the "create sequence ...
start N"
before creating the table.
2. Upon INSERTing to a serial column, explicitly given 0 value or
'default' keyword
or omitted field (implicit default) should be interchangeable.
3. When a serial field value is given in an INSERT or UPDATE statement
and the value is larger the the current value of the sequence then the
sequence
should be modified accordingly.
This is the way Informix handles its serial type, although it doesn't seem
to have a visible sequence bound to the serial column.
Is it feasible in the 8.2 timeframe?
Thanks in advance,
Zoltán Böszörményi