From: vijay <vijay@caliberinfo.net>
To: pgsql-admin@postgresql.org
Subject: Fw: ERROR: Relation product does not exist!!
Date: Fri, 22 Apr 2005 19:44:47 +0530
Message-ID: <07a001c54745$a4bd6bc0$0a01a8c0@caliber> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: vijay@caliberinfo.net
Subject: Re: Fw: ERROR: Relation product does not exist!!
In-Reply-To: <07a001c54745$a4bd6bc0$0a01a8c0@caliber>
References: <07a001c54745$a4bd6bc0$0a01a8c0@caliber>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox