Re: Trigger trouble

Поиск
Список
Период
Сортировка
От Simon Riggs
Тема Re: Trigger trouble
Дата
Msg-id 1167299488.3633.72.camel@silverbirch.site
обсуждение исходный текст
Ответ на Trigger trouble  ("Sandy Spence" <axs@aber.ac.uk>)
Список 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



В списке pgsql-admin по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: 8.2.0 upgrade issue: postmaster -S
Следующее
От: Cedric BUSCHINI
Дата:
Сообщение: Performances