Skip site navigation (1) Skip section navigation (2)

Re: Trigger trouble

From: "Simon Riggs" <simon(at)2ndquadrant(dot)com>
To: "Sandy Spence" <axs(at)aber(dot)ac(dot)uk>
Cc: <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Trigger trouble
Date: 2006-12-28 09:51:27
Message-ID: 1167299488.3633.72.camel@silverbirch.site (view raw or flat)
Thread:
Lists: pgsql-admin
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



In response to

pgsql-admin by date

Next:From: Cedric BUSCHINIDate: 2006-12-28 09:59:39
Subject: Performances
Previous:From: Tom LaneDate: 2006-12-28 01:34:08
Subject: Re: 8.2.0 upgrade issue: postmaster -S

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group