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
