| From: | Somazx Interesting <somazx(at)home(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Can not pg_dumpall |
| Date: | 2001-06-08 21:06:57 |
| Message-ID: | 5.1.0.14.0.20010608135049.02fd8888@mail.rct1.bc.wave.home.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
At 01:30 PM 6/8/2001 -0700, you wrote:
> > At 02:18 PM 6/8/2001 -0400, Tom Lane wrote:
> > >Somazx Interesting <somazx(at)home(dot)com> writes:
> > > > getTables(): SELECT (funcname) for trigger sa_eval_trigger_608
> returned 0
> > > > tuples. Expected 1.
> > > > pg_dump failed on OnEd, exiting
>
>This is easy to fix, actually. You need to change reltriggers on the
>pg_class row for lessontable_548_118 to match the number of triggers that
>are really there (7).
Thanks. You've bailed me out once more. I was able to backup the data now -
and I can relax a little.
I was hoping that the problems preventing me from dropping those tables and
doing a pg_dump would resolve the slowness in the system in general
(especially dropping tables) - and it did!!
Does that make any sense though?
Andy.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thalis A. Kalfigopoulos | 2001-06-08 21:23:02 | Re: Cleanly cancel a query. |
| Previous Message | Thalis A. Kalfigopoulos | 2001-06-08 21:04:07 | Re: Cleanly cancel a query. |