"ERROR: too many trigger records found for relation ...." - Mailing list pgsql-bugs

From Frank van Vugt
Subject "ERROR: too many trigger records found for relation ...."
Date
Msg-id 200505252243.52216.ftm.van.vugt@foxi.nl
Whole thread Raw
List pgsql-bugs
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.

pgsql-bugs by date:

Previous
From: "Haluk GUNCER"
Date:
Subject: BUG #1680: pw_shadow BUS ERROR when initdb called.
Next
From: Neil Conway
Date:
Subject: Re: BUG #1678: pw_shadow BUS ERROR