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
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
Στις 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?
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