Fw: ERROR: Relation product does not exist!!

From: "vijay" <vijay(at)caliberinfo(dot)net>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: Fw: ERROR: Relation product does not exist!!
Date: 2005-04-22 14:14:47
Message-ID: 07a001c54745$a4bd6bc0$0a01a8c0@caliber
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


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

Browse pgsql-admin by date

  From Date Subject
Next Message FBaron 2005-04-22 15:00:48 Where can I find the contrib/dbsize. contrib/....
Previous Message Raghunath Ganti 2005-04-22 09:19:03 Bytea in Postgres And Hibernate