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
