Thread: PGDUMP BLOB PROBLEM

PGDUMP BLOB PROBLEM

From
omkar prabhu
Date:
Hi,

I am using postgres 7.0.3,
pg_dump,pg_restore version 7.2.1
I have database with lo type column

while restoring i get following message

NOTICE:  DefineType: attribute "storage" not
recognized

The data restore is proper,except for the blob field
if use lo_export to extract the blob its say the
oid does not exist.

Regards
omkar

__________________________________
Do you Yahoo!?
Free Pop-Up Blocker - Get it now
http://companion.yahoo.com/

Re: PGDUMP BLOB PROBLEM

From
Tom Lane
Date:
omkar prabhu <omprab@yahoo.com> writes:
> I am using postgres 7.0.3,
> pg_dump,pg_restore version 7.2.1

You can't use a newer pg_dump/pg_restore to restore into an older server.

7.0.3 is ancient history anyway; you should update.

            regards, tom lane