Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 7D0969FB1E1 for ; Wed, 25 Oct 2006 14:13:35 -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 11584-04 for ; Wed, 25 Oct 2006 14:13:30 -0300 (ADT) X-Greylist: delayed 01:53:22.606301 by SQLgrey- Received: from smtp3.ualg.pt (smtp3.ualg.pt [193.136.224.6]) by postgresql.org (Postfix) with ESMTP id 70A349F9F74 for ; Wed, 25 Oct 2006 14:13:30 -0300 (ADT) Received: by smtp3.ualg.pt (Postfix, from userid 501) id 805A71E18E6; Wed, 25 Oct 2006 18:13:28 +0100 (WEST) Received: from localhost (smtp3.ualg.pt [127.0.0.1]) by smtp3.ualg.pt (Postfix) with ESMTP id 649921E17F3 for ; Wed, 25 Oct 2006 18:13:28 +0100 (WEST) X-Virus-Scanned: amavisd-new at ualg.pt Received: from smtp3.ualg.pt ([127.0.0.1]) by localhost (smtp3.ualg.pt [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id fFaxXTjw5pa9 for ; Wed, 25 Oct 2006 18:13:27 +0100 (WEST) Received: from [10.17.20.14] (unknown [10.17.20.14]) by smtp3.ualg.pt (Postfix) with ESMTP id 8B3641E18A7 for ; Wed, 25 Oct 2006 18:13:27 +0100 (WEST) Message-ID: <453F9B32.7090601@ualg.pt> Date: Wed, 25 Oct 2006 18:13:22 +0100 From: =?ISO-8859-1?Q?Lu=EDs_Sousa?= User-Agent: Debian Thunderbird 1.0.2 (X11/20060926) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-admin Subject: pg_restore and drop table problems Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.553 tagged_above=0 required=5 tests=AWL, SPF_PASS X-Spam-Level: X-Archive-Number: 200610/162 X-Sequence-Number: 23465 Hi again, Version: 7.4.7-6sarge3 Structure of database: table A (id_a primary key) <-> table B (id_a,id_c - foreign keys from table A and table C) <-> table C (id_c primary key). Table A, table B and table C have one record for test purposes Problem: After error on pg_restore can't drop table that gave error! Steps to reproduce: 1. pg_dump with -Fc option from database 2. A column name on table C is changed 3. pg_restore using option -S and --disable-triggers with error identifying that a column on table C was changed 4. drop table B. Can't drop table giving ERROR: relation "B" has reltriggers = 0 What could be happening here? Best regards, Luís Sousa