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

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

From
Frank van Vugt
Date:
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.