PostgreSQL Bugs - "ERROR: too many trigger records found for relation ...."

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

"ERROR: too many trigger records found for relation ...."

Frank van Vugt

2005-05-25, 8:24 pm

L.S.

This may not 'qualify' as a bug, but just in case:

# select version();
version
------------------------------------------------------------------------
PostgreSQL 8.0.3 on i586-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2.3

=> use pg_restore to restore a dump

=> during the restore, connect to the database through psql and as soon as the
data itself has been put back, issue an 'analyse verbose'

=> every now and then the analyse will clash with probably the restore of
triggers resulting in the following message in the terminal:

"ERROR: too many trigger records found for relation ...."

=> re-issuing the analyse after the restore is done completes successfully

--
Best,

Frank.

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql
.org

Sponsored Links