Re: [GENERAL] Can not pg_dumpall

2001-06-08 Thread Somazx Interesting
At 01:30 PM 6/8/2001 -0700, you wrote: > > At 02:18 PM 6/8/2001 -0400, Tom Lane wrote: > > >Somazx Interesting <[EMAIL PROTECTED]> writes: > > > > getTables(): SELECT (funcname) for trigger sa_eval_trigger_608 > returned 0 > > > > tuples. Expected 1. > > > > pg_dump failed on OnEd, exiting > >Thi

Re: [GENERAL] Can not pg_dumpall

2001-06-08 Thread Tom Lane
Somazx Interesting <[EMAIL PROTECTED]> writes: > Taking that to mean, "try deleting that orphaned trigger" - but since I > don't know which table that trigger was on - I did it by deleting it > through pg_trigger, I now get somewhat worse errors: > getTables(): relation 'lessontable_548_118': 8

Re: [GENERAL] Can not pg_dumpall

2001-06-08 Thread Stephan Szabo
On Fri, 8 Jun 2001, Somazx Interesting wrote: > At 02:18 PM 6/8/2001 -0400, Tom Lane wrote: > >Somazx Interesting <[EMAIL PROTECTED]> writes: > > > getTables(): SELECT (funcname) for trigger sa_eval_trigger_608 returned 0 > > > tuples. Expected 1. > > > pg_dump failed on OnEd, exiting > > > >Kin

Re: [GENERAL] Can not pg_dumpall

2001-06-08 Thread Somazx Interesting
At 02:18 PM 6/8/2001 -0400, Tom Lane wrote: >Somazx Interesting <[EMAIL PROTECTED]> writes: > > getTables(): SELECT (funcname) for trigger sa_eval_trigger_608 returned 0 > > tuples. Expected 1. > > pg_dump failed on OnEd, exiting > >Kinda looks like you dropped some function that was still referen

Re: [GENERAL] Can not pg_dumpall

2001-06-08 Thread Tom Lane
Somazx Interesting <[EMAIL PROTECTED]> writes: > getTables(): SELECT (funcname) for trigger sa_eval_trigger_608 returned 0 > tuples. Expected 1. > pg_dump failed on OnEd, exiting Kinda looks like you dropped some function that was still referenced by a trigger. Better drop the trigger too.

[GENERAL] Can not pg_dumpall

2001-06-07 Thread Somazx Interesting
Can anyone help me with this error message I get when I attempt to dump my database? [dfunct@localhost dfunct]$ pg_dumpall > /home/dfunct/OnEd_backups/OnEd_Wednesday.sql getTables(): SELECT (funcname) for trigger sa_eval_trigger_608 returned 0 tuples. Expected 1. pg_dump failed on OnEd, exitin