Hi all,

From Redhad Linux 7, I copied all PostgreSQL 7.0.3 database


files and moved all the database files to Fedora Linux 10.

I didn't take a dump using pg_dump.

Then, on Fedora Linux 10, I uninstalled PostgreSQL 7.3.4 and installed PostgreSQL 7.0.3.

Postmaster is running and when I list using \d all the tables are

listed. But, When I try select * from product; I get,

ERROR: Relation product does not exist. I tried with

select * from "product"; also.

For select * from pga_schema; I get,

ERROR: Cannot find attribute 1 of relation default_test.

Could anyone suggest a solution for this problem please?

Many thanks in advance.

Vijay