X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 49F6B5371C for ; Fri, 22 Apr 2005 11:15:10 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 44772-03 for ; Fri, 22 Apr 2005 14:15:01 +0000 (GMT) Received: from qmail-b.directi.com (qmail-b.directi.com [203.199.107.94]) by svr1.postgresql.org (Postfix) with SMTP id F0A5652D3B for ; Fri, 22 Apr 2005 11:14:57 -0300 (ADT) Received: (qmail 27252 invoked by uid 0); 22 Apr 2005 08:45:05 -0000 Received: from dsl-tn-007.248.247.61.touchtelindia.net (HELO caliber) (61.247.248.7) by qmail-b.directi.com with SMTP; 22 Apr 2005 08:45:04 -0000 Message-ID: <07a001c54745$a4bd6bc0$0a01a8c0@caliber> From: "vijay" To: Subject: Fw: ERROR: Relation product does not exist!! Date: Fri, 22 Apr 2005 19:44:47 +0530 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_079D_01C54773.BD6EBF10" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.3790.0 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.028 tagged_above=0 required=5 tests=HTML_60_70, HTML_MESSAGE X-Spam-Level: X-Archive-Number: 200504/335 X-Sequence-Number: 17348 This is a multi-part message in MIME format. ------=_NextPart_000_079D_01C54773.BD6EBF10 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi all, From Redhad Linux 7, I copied all PostgreSQL 7.0.3 database=20 files and moved all the database files to Fedora Linux 10.=20 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=20 listed. But, When I try select * from product; I get, ERROR: Relation product does not exist. I tried with=20 select * from "product"; also. =20 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?=20 Many thanks in advance. Vijay ------=_NextPart_000_079D_01C54773.BD6EBF10 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
 
Hi = all,
 
 From Redhad Linux 7, I copied all = PostgreSQL=20 7.0.3 database
 
files and moved all the database = files to=20 Fedora Linux 10.
 
I didn't take a dump using = pg_dump.
 
Then, on Fedora Linux 10,  I = uninstalled=20 PostgreSQL 7.3.4 and installed PostgreSQL 7.0.3.
 
Postmaster is running and when I list = using \d all=20 the tables are
 
listed. But, When I=20 try select * from product; I get,
 
ERROR: Relation product does = not=20 exist. I tried with
 
select * from = "product";=20 also. 
 
For select * from = pga_schema; I=20 get,
 
ERROR: Cannot find attribute 1 = of relation=20 default_test.

Could anyone suggest a = solution for this=20 problem please?
 
Many thanks in advance.
 
Vijay
------=_NextPart_000_079D_01C54773.BD6EBF10--