Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id EC7CC650E87 for ; Thu, 3 Jul 2008 11:19:55 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 36072-04 for ; Thu, 3 Jul 2008 11:19:47 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from vilnius.balt.net (vilnius.balt.net [195.14.170.14]) by postgresql.org (Postfix) with ESMTP id A303764FD64 for ; Thu, 3 Jul 2008 11:19:51 -0300 (ADT) Received: from nSoft.lt (unknown [217.117.29.29]) by vilnius.balt.net (Postfix) with ESMTP id A8DD03A0F75 for ; Thu, 3 Jul 2008 17:19:48 +0300 (EEST) Received: from [192.168.16.1] (unknown [192.168.16.1]) by nSoft.lt (Postfix) with ESMTP id B9747BF317 for ; Thu, 3 Jul 2008 17:49:14 +0000 (GMT) Message-ID: <486CE004.8000400@nsoft.lt> Date: Thu, 03 Jul 2008 17:19:48 +0300 From: Julius Tuskenis User-Agent: Thunderbird 2.0.0.14 (Windows/20080421) MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: changing sequence in serial field Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.179 tagged_above=0 required=5 tests=AWL=0.179 X-Spam-Level: X-Archive-Number: 200807/40 X-Sequence-Number: 29650 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; 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