Thread: pg_dump get error
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
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