Joe Conway <joseph.conway@home.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