Re: pgdump fails on trigger function

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: pgdump fails on trigger function
Дата
Msg-id 29997.1008778110@sss.pgh.pa.us
обсуждение исходный текст
Ответ на pgdump fails on trigger function  (Randall Perry <rgp@systame.com>)
Ответы Re: pgdump fails on trigger function
Список pgsql-admin
Randall Perry <rgp@systame.com> writes:
> Anyone know what this means:
> getTables(): SELECT (funcname) for trigger cust_modification_date returned 0
> tuples. Expected 1.

It would seem you have dropped the function which that trigger uses.
(If you drop and recreate a function, you have to drop and recreate
any triggers that use it too.  The triggers refer to the function by
OID, but the recreated function will have a different OID.)

            regards, tom lane

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

Предыдущее
От: Randall Perry
Дата:
Сообщение: pgdump fails on trigger function
Следующее
От: "Zhang, Anna"
Дата:
Сообщение: poor performance of loading data