Re: 7.2b3 pg_dump, general 7.2b3 comments

Joe Conway <joseph(dot)conway(at)home(dot)com> writes:
> Is pg_dump supposed to work against prior version databases?

Since 7.1.1 we've tried to make it do so.

> # pg_dump -h 172.16.1.84 -U postgres -t el_names -i lt_lcat > el_names.dmp
> Password: <types in password>
> pg_dump: query to obtain list of tables failed: ERROR: Attribute
> 'relhasoids' not found

<scratches head> Odd. There's only one query in pg_dump that touches
relhasoids, and it's set up to only be used when "remoteVersion >= 70200".
It seems to work here, too: I can dump from a 7.1 or even 7.0 server
with current pg_dump. Would you burrow in there and see what's screwing
up the version-check code?

BTW, what happens if you leave off -i? It shouldn't be necessary.

regards, tom lane