Обсуждение: pg_dump get error

Поиск
Список
Период
Сортировка

pg_dump get error

От
Dorothy Yung
Дата:
Hi,

    Got the following error when using pg_dump "getTables(): SELECT
(funcname) for trigger returned 0 tuples. Expected 1.

    Having searched the archive and found somebody got similar problem
(http://archives.postgresql.org/pgsql-admin/2001-12/msg00126.php), but
my problem now is that pg_dump doesn't show on which trigger the error
occurs.

    Any hint?

MK Tam

Re: pg_dump get error

От
Tom Lane
Дата:
Dorothy Yung <yungkaki@so-net.com.hk> writes:
>     Having searched the archive and found somebody got similar problem
> (http://archives.postgresql.org/pgsql-admin/2001-12/msg00126.php), but
> my problem now is that pg_dump doesn't show on which trigger the error
> occurs.

Best bet is to run pg_dump with query logging turned on, and look in the
postmaster log to see the query that fails.

            regards, tom lane