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.
In response to
pgsql-admin by date
|Next:||From: Cedric BUSCHINI||Date: 2006-12-28 09:59:39|
|Previous:||From: Tom Lane||Date: 2006-12-28 01:34:08|
|Subject: Re: 8.2.0 upgrade issue: postmaster -S |