| 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: | Whole Thread | Raw Message | 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.
| 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 |