Hi, Under Postgresql 7.0.2 (linux86), I've just noticed a strange behavior (I suppose it's a bug) with alter table, but don't know if it's a known one or not: the following works great: db=> CREATE TABLE foo (id SERIAL); NOTICE: CREATE TABLE will create implicit sequence 'foo_id_seq' for SERIAL column 'foo.id' NOTICE: CREATE TABLE/UNIQUE will create implicit index 'foo_id_key' for table 'foo' CREATE db=> \ds List of relations Name | Type | Owner ------------+----------+-------- foo_id_seq | sequence | jerome (1 row) but the following doesn't create the sequence bar_id_seq: db=> CREATE TABLE bar (somefield TEXT); CREATE db=> ALTER TABLE bar ADD COLUMN id SERIAL; ALTER db=> \ds List of relations Name | Type | Owner ------------+----------+-------- foo_id_seq | sequence | jerome (1 row) The ALTER command should have created a sequence named bar_id_seq, as well as an index but has done none. I suppose it's a bug. also it would be fine if ALTER could rename other things than just tables; bye, Jerome ALET - [EMAIL PROTECTED] - http://cortex.unice.fr/~jerome Faculte de Medecine de Nice - http://noe.unice.fr - Tel: 04 93 37 76 30 28 Avenue de Valombrose - 06107 NICE Cedex 2 - FRANCE