[BUGS] "ERROR: too many trigger records found for relation ...."

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

[BUGS] "ERROR: too many trigger records found for relation ...."

Frank van Vugt
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 [hidden email]