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.

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 referenced by a

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 Kinda looks like you

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 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 This is easy to fix,

[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,