Cedric BRINER wrote:
the idea is to drop the ``old_test'' table. But before doing this,
> I'd like to alter the table ``test'' to use the sequence
> ``test_id_seq'' instead of ``test_new_seq_id''?
ALTER TABLE new_table ALTER COLUMN my_column DROP DEFAULT;
ALTER TABLE new_table ALTER COLUMN my
hi,
let me explain what I have done, and what I'd like to do with a small example:
create table test (id serial, nom varchar(32));
INSERT INTO test ("nom") values ('cedric');
INSERT INTO test ("nom") values ('felix');
INSERT INTO test ("nom") values ('julien');
create table new_test (id serial,
