Just wanted to chime in here, I'm not on the mailing list so please cc me
any replies.
The techniques you have described I am surprised to not hear the solution
I am employing:
=# create table foo (id int default nextval('foo_seq'::text),
(# data text);
CREATE
=# create sequence foo_seq;
CREATE
=#
Then if you insert data, the default value will be a sequence that has
several properties to it:
=# \d foo_seq
Sequence "foo_seq"
Attribute | Type
---------------+---------
sequence_name | name
last_value | integer
increment_by | integer
max_value | integer
min_value | integer
cache_value | integer
log_cnt | integer
is_cycled | "char"
is_called | "char"
=# select * from foo_seq;
sequence_name | last_value | increment_by | max_value | min_value | cache_value | log_cnt | is_cycled | is_called
---------------+------------+--------------+------------+-----------+-------------+---------+-----------+-----------
foo_seq | 1 | 1 | 2147483647 | 1 | 1 | 1 | f | f
(1 row)
=# insert into foo (data) values ('fee');
INSERT 107739 1
=# insert into foo (data) values ('fie');
INSERT 107740 1
=# insert into foo (data) values ('fo');
INSERT 107741 1
=# insert into foo (data) values ('fum');
INSERT 107742 1
=# select * from foo;
id | data
----+------
1 | fee
2 | fie
3 | fo
4 | fum
(4 rows)
=# select * from foo_seq;
sequence_name | last_value | increment_by | max_value | min_value | cache_value | log_cnt | is_cycled | is_called
---------------+------------+--------------+------------+-----------+-------------+---------+-----------+-----------
foo_seq | 4 | 1 | 2147483647 | 1 | 1 | 30 | f | t
(1 row)
=#
I believe this is how things were meant to be, no?
--
Todd Fries .. todd@fries.net