On the client machine:
$ psql --version
psql (PostgreSQL) 8.1.3
At the host:
monashprotein=> select version();
version
-------------------------------------------------------------------------------------------------
PostgreSQL 7.4.8 on ia64-unknown-linux-gnu, compiled by GCC gcc (GCC) 3.3.5 (Debian 1:3.3.5-13)
(1 row)
Please reply to all, ensuring that the post is placed on the pqsql-general mailing list.
Klint Gore wrote:
On Thu, 16 Mar 2006 12:51:03 +1100, Noel Faux <noel.faux@med.monash.edu.au> wrote:
This is a multi-part message in MIME format.
----------------------------------------------------------------
Klint Gore wrote:
On Thu, 16 Mar 2006 12:33:26 +1100, Noel Faux <noel.faux@med.monash.edu.au> wrote:
Has anyone had this problem?
while in psql:
monashprotein=> \d alignment
ERROR: column c2.reltablespace does not exist
monashprotein=> \d region
ERROR: column c2.reltablespace does not exist
monashprotein=>
monashprotein=> \d
ERROR: relation "pg_catalog.pg_roles" does not exist
Any pointers would be really appreciated!
are you using an 8.x psql against a 7.x database?
7.4.8
7.4.8 doesn't have tablespaces so the version of psql that you have must
be a 8.x?
if you run "psql --version", does it say 7.4.8 or 8.x.x?
if you execute the query "select version();" what does it say?
I've got 8.1 on my workstation with 7.4.7 on a development server (dev1)
and it says the following -
D:\>psql --version
psql (PostgreSQL) 8.1.0
D:\>psql -h dev1 template1
template1=# select version(); version
---------------------------------------------------------------------------------------------------------PostgreSQL 7.4.7 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2.2 20030222 (Red Hat Linux 3.2.2-5)
(1 row)
template1=# \d
ERROR: relation "pg_catalog.pg_roles" does not exist
template1=# \d pg_class
ERROR: column c2.reltablespace does not exist
template1=#
klint.
+---------------------------------------+-----------------+
: Klint Gore : "Non rhyming :
: EMail : kg@kgb.une.edu.au : slang - the :
: Snail : A.B.R.I. : possibilities :
: Mail University of New England : are useless" :
: Armidale NSW 2351 Australia : L.J.J. :
: Fax : +61 2 6772 5376 : :
+---------------------------------------+-----------------+