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

From: Frank van Vugt <ftm(dot)van(dot)vugt(at)foxi(dot)nl>
To: pgsql-bugs(at)postgresql(dot)org
Subject: "ERROR: too many trigger records found for relation ...."
Date: 2005-05-25 20:43:51
Message-ID: 200505252243.52216.ftm.van.vugt@foxi.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Browse pgsql-bugs by date

  From Date Subject
Next Message Neil Conway 2005-05-26 01:02:15 Re: BUG #1678: pw_shadow BUS ERROR
Previous Message John Hansen 2005-05-25 04:58:09 Re: BUG #1678: pw_shadow BUS ERROR