Skip site navigation (1) Skip section navigation (2)

"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 (view raw or flat)
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.

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group