is this a bug ?

hi,

I'm facing this problem

DROP TABLE test;
DROP TABLE new_test;
CREATE TABLE test (id serial NOT NULL UNIQUE, 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 NOT NULL UNIQUE, nom varchar(32));
INSERT INTO new_test SELECT * FROM test;

ALTER TABLE new_test ALTER COLUMN id SET DEFAULT nextval('public.test_id_seq');
DROP TABLE test;

ALTER TABLE new_test RENAME TO test;
ALTER TABLE new_test_id_key RENAME TO test_id_key;

DROP SEQUENCE new_test_id_seq ;
-- this give an error... is this normal

is this the normal behaviour ?

Ced.
--

Cedric BRINER