RE: Re: pg_dump tries to do too much per query

......

> The general issue still remains: if a database contains an inconsistency
> or error, introduced by whatever means (and there'll always be bugs),
> a pg_dump failure is likely to be the first notice a dbadmin has about it.
> So it behooves us to make sure that pg_dump issues error messages that
> are as specific as possible. In particular, if there is a specific
> object such as a view or rule that's broken, pg_dump should take care
> that it can finger that particular object, not have to report a generic
> "SELECT failed" error message.
>
> This problem has been around for a long time, of course, but now that
> we have someone who's taking an active interest in fixing pg_dump ;-)
> I'm hoping something will get done about it...
>
> regards, tom lane
`-----Original Message-----
From: Tom Lane [SMTP:tgl(at)sss(dot)pgh(dot)pa(dot)us]
Sent: Tuesday, September 19, 2000 11:13 AM
To: Philip Warner
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: [HACKERS] Re: pg_dump tries to do too much per
query

I can't agree with this more... On several occasions I have had
databases that apparently were working fine with no problems, and the only
indication of the problem was that pg_dump would fail. while this is nice
in that I now know there is a problem, I had very small info on where to
start looking.