Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 31CD49FA320 for ; Thu, 28 Dec 2006 05:52:24 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024) with ESMTP id 21237-10 for ; Thu, 28 Dec 2006 05:52:19 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from mail01.enterprisedb.com (mail01.enterprisedb.com [63.246.7.168]) by postgresql.org (Postfix) with ESMTP id 54E249FA2EC for ; Thu, 28 Dec 2006 05:52:19 -0400 (AST) thread-index: AccqZd8BzzOQC6c0QyWWVxhiJdZzJw== Received: from [192.168.0.22] ([84.12.182.179]) by mail01.enterprisedb.com with Microsoft SMTPSVC(6.0.3790.1830); Thu, 28 Dec 2006 04:52:21 -0500 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.2757 Content-Class: urn:content-classes:message Importance: normal Subject: Re: Trigger trouble From: "Simon Riggs" To: "Sandy Spence" Cc: In-Reply-To: <000d01c724ea$7a7b8110$520b3cc1@pc2axs> References: <000d01c724ea$7a7b8110$520b3cc1@pc2axs> Content-Type: text/plain; charset="iso-8859-1" Date: Thu, 28 Dec 2006 09:51:27 +0000 Message-ID: <1167299488.3633.72.camel@silverbirch.site> MIME-Version: 1.0 X-Mailer: Evolution 2.6.0 Content-Transfer-Encoding: 7bit X-OriginalArrivalTime: 28 Dec 2006 09:52:22.0078 (UTC) FILETIME=[DEC3B5E0:01C72A65] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200612/346 X-Sequence-Number: 24138 On Thu, 2006-12-21 at 10:26 +0000, Sandy Spence wrote: > I get the following error when performing a pg_dump > > dumping database "ltt"... > pg_dump: WARNING: owner of data type trigger appears to be invalid > > the owner and database exists, I have run the following select statement, > > select pg_class.oid, pg_trigger.tgrelid from pg_trigger left join pg_class > on pg_trigger.tgrelid=pg_class.oid; From the error message it appears you have a data type called "trigger", which appears to be invalidated. -- Simon Riggs EnterpriseDB http://www.enterprisedb.com