Thread: Strange error in 7.3.1

Strange error in 7.3.1

From
"Duncan Adams (DNS)"
Date:
Hi all

Does any one know why im getting the following errors.

This is the second postgres database on this box the first one works fine and is version 7.2.1

Thanx

Duncan.

box stats.

uname -a
Linux vodasyslog01 2.4.18-18.7.xsmp #1 SMP Wed Nov 13 19:01:42 EST 2002 i686 unknown

==>

[webadmin@vodasyslog01 databases]$ su - postgres
Password:
bash-2.05$ cd /databases/postgresql/bin/
bash-2.05$ ./psql -l
ERROR:  parser: parse error at or near "("
bash-2.05$ ./psql
ERROR:  parser: parse error at or near "."
Welcome to psql 7.3.1, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms
       \h for help with SQL commands
       \? for help on internal slash commands
       \g or terminate with semicolon to execute query
       \q to quit

postgres=> \l
ERROR:  parser: parse error at or near "("
postgres=> \c wireman
You are now connected to database wireman.
ERROR:  parser: parse error at or near "."
wireman=> /q
wireman-> ;
ERROR:  parser: parse error at or near "/"
wireman=> ;
wireman=> \q
bash-2.05$ /databases/postgresql/bin/psql
ERROR:  parser: parse error at or near "."
Welcome to psql 7.3.1, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms
       \h for help with SQL commands
       \? for help on internal slash commands
       \g or terminate with semicolon to execute query
       \q to quit

postgres=> \l
ERROR:  parser: parse error at or near "("
postgres=> \q
bash-2.05$ pwd
/databases/postgresql/bin
bash-2.05$ ./psql -l
ERROR:  parser: parse error at or near "("
bash-2.05$ ./psql template1
ERROR:  parser: parse error at or near "."
Welcome to psql 7.3.1, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms
       \h for help with SQL commands
       \? for help on internal slash commands
       \g or terminate with semicolon to execute query
       \q to quit

template1=> \l
ERROR:  parser: parse error at or near "("
template1=> \c wireman
You are now connected to database wireman.
ERROR:  parser: parse error at or near "."
wireman=> \dt
ERROR:  parser: parse error at or near "."
wireman=> \d
ERROR:  parser: parse error at or near "."
wireman=>
wireman=> \q
bash-2.05$ uname -a
Linux vodasyslog01 2.4.18-18.7.xsmp #1 SMP Wed Nov 13 19:01:42 EST 2002 i686
unknown
bash-2.05$
“This e-mail is sent on the Terms and Conditions that can be accessed by Clicking on this link
http://www.vodacom.net/legal/email.asp" 

Re: Strange error in 7.3.1

From
Tom Lane
Date:
"Duncan Adams  (DNS)" <duncan.adams@vcontractor.co.za> writes:
> bash-2.05$ ./psql
> ERROR:  parser: parse error at or near "."
> Welcome to psql 7.3.1, the PostgreSQL interactive terminal.

Looks to me like you are trying to use 7.3 psql to talk to a 7.2 or
older server.  This will mostly work, but a lot of backslash commands
now use syntax that the older server won't understand (such as schema
prefixes, which is what causes the startup error).  Usually you want
to use a psql of the same vintage as the server.

            regards, tom lane