Re: [ADMIN] changing sequence in serial field

2008-07-04 Thread Tom Lane
Julius Tuskenis <[EMAIL PROTECTED]> writes: > 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. It's a

Re: [ADMIN] changing sequence in serial field

2008-07-03 Thread Julius Tuskenis
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

Re: [ADMIN] changing sequence in serial field

2008-07-03 Thread Achilleas Mantzios
Στις 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?

[ADMIN] changing sequence in serial field

2008-07-03 Thread 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_b