| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Cedric BUSCHINI | 2006-12-28 09:59:39 | Performances |
| Previous Message | Tom Lane | 2006-12-28 01:34:08 | Re: 8.2.0 upgrade issue: postmaster -S |