dbTalk Databases Forums  

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

mailing.database.pgsql-bugs mailing.database.pgsql-bugs


Discuss [BUGS] "ERROR: too many trigger records found for relation ...." in the mailing.database.pgsql-bugs forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Frank van Vugt
 
Posts: n/a

Default [BUGS] "ERROR: too many trigger records found for relation ...." - 05-25-2005 , 03:44 PM






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 majordomo (AT) postgresql (DOT) org

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.