Hello Achilleas.
I think you are wrong on this point - I can create some sequence (the
owner is set) and then drop it easily. I think this is because
b_prekes_br_kodas_pbk_id_seq1 was created automatically creating serial field and is in some way connected to it. Thats why I get error saying "...column pbk_id requires it." Any way I can't find a way to find and alter this dependency.
Achilleas Mantzios rašė:
Στις Thursday 03 July 2008 18:19:27 ο/η Julius Tuskenis έγραψε:
Sorry - that doesnt work.
That was in 8.3.3
Your mileage may vary. But the key is to get rid of the dependency.
try
ALTER SEQUENCE b_prekes_br_kodas_pbk_id_seq1 OWNED BY NONE;
first, adn then drop.
ERROR: syntax error at or near "OWNED"
LINE 1: ALTER SEQUENCE b_prekes_br_kodas_pbk_id_seq1 OWNED BY NONE;
^
********** Error **********
ERROR: syntax error at or near "OWNED"
SQL state: 42601
Character: 46
I also tried ALTER table b_prekes_br_kodas_pbk_id_seq1 OWNER TO NONE;
but this gives:
ERROR: role "none" does not exist
********** Error **********
ERROR: role "none" does not exist
SQL state: 42704
Achilleas Mantzios rašė:
Στις Thursday 03 July 2008 17:19:48 ο/η Julius Tuskenis έγραψε:
Hello
I noticed, that some serial field is using wrong sequence, so I altered
the default value pointing to the sequence I want, but now I cant delete
currently no longer used sequence. Did I do someting wrong changing it?
PgSQL 8.1 on Gentoo Linux.
What I try to do
DROP SEQUENCE b_prekes_br_kodas_pbk_id_seq1;
try
ALTER SEQUENCE b_prekes_br_kodas_pbk_id_seq1 OWNED BY NONE;
first, adn then drop.
Result
ERROR: cannot drop sequence b_prekes_br_kodas_pbk_id_seq1 because table
b_prekes_br_kodas column pbk_id requires it
HINT: You may drop table b_prekes_br_kodas column pbk_id instead.
********** Error **********
ERROR: cannot drop sequence b_prekes_br_kodas_pbk_id_seq1 because table
b_prekes_br_kodas column pbk_id requires it
SQL state: 2BP01
Hint: You may drop table b_prekes_br_kodas column pbk_id instead.
--
Julius Tuskenis
Programavimo skyriaus vadovas
UAB nSoft
mob. +37068233050
--
Julius Tuskenis
Programavimo skyriaus vadovas
UAB nSoft
mob. +37068233050
