X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 831629F9F3D for ; Tue, 9 May 2006 10:04:30 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 54662-08 for ; Tue, 9 May 2006 10:04:23 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from fafnir.androme.com (fafnir.androme.com [62.58.96.158]) by postgresql.org (Postfix) with ESMTP id 445759F946D for ; Tue, 9 May 2006 10:04:23 -0300 (ADT) Received: by fafnir.androme.com (Postfix, from userid 1003) id 8861DB91690; Tue, 9 May 2006 15:04:21 +0200 (CEST) Message-ID: <44609355.4090102@andromeiberica.com> Date: Tue, 09 May 2006 15:04:21 +0200 From: Arnau Reply-To: arnaulist@andromeiberica.com User-Agent: Mozilla Thunderbird 1.0.6 (Windows/20050716) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Re: Error dropping tables: "ERROR: could not find tuple References: <4460544A.7060606@andromeiberica.com> In-Reply-To: <4460544A.7060606@andromeiberica.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/85 X-Sequence-Number: 21617 Arnau wrote: > Hi all, > > I have problems droppping some tables in a DB running on postgreSQL > 7.4.2. Below you have an example of what is happening: > > coltr_demo=# drop table agenda_users_groups; > ERROR: could not find tuple for trigger 112070831 > > I haven't found anything about how to solve this, anybody knows? > > Thanks The solution I have done is: select oid from pg_class where relname = 'agenda_users_groups'; oid ---------- 27970458 (1 row) begin; delete from pg_class where oid = 27970458; delete from pg_depend where objid = 27970458; delete from pg_constraint where conrelid = 27970458; commit; Anybody knows if I should delete anything else? -- Arnau