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.
pgsql-admin by date
|Next:||From: FBaron||Date: 2005-04-22 15:00:48|
|Subject: Where can I find the contrib/dbsize. contrib/....|
|Previous:||From: Raghunath Ganti||Date: 2005-04-22 09:19:03|
|Subject: Bytea in Postgres And Hibernate|