Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group