Thread: Upgraded from 7.2 to 7.3

Hi all,

I just tried upgrading my system from 7.2.3 to 7.3.2

Everything seems to be fine with the data but whenever I try to access
table information using psql it gives me errors.  Here is a log of whats
been going on.

postgres|16:14:40|~> psql sds
ERROR:  parser: parse error at or near "."
ERROR:  parser: parse error at or near "."
Welcome to psql 7.3.2, 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

sds=> \l
ERROR:  parser: parse error at or near "("
ERROR:  parser: parse error at or near "("
sds=> \d
ERROR:  parser: parse error at or near "."
ERROR:  parser: parse error at or near "."
sds=> \d seminar
ERROR:  parser: parse error at or near "."
ERROR:  parser: parse error at or near "."
sds=> \q
postgres|16:14:50|~>

if anybody has any ideas as to what I've done that would be greatly
appreciated.

Cheers
--
Tom Ansley <tansley@law.du.edu>
Graduate Tax Program Denver University

Tom Ansley <tansley@law.du.edu> writes:
> I just tried upgrading my system from 7.2.3 to 7.3.2

> postgres|16:14:40|~> psql sds
> ERROR:  parser: parse error at or near "."
> ERROR:  parser: parse error at or near "."
> Welcome to psql 7.3.2, the PostgreSQL interactive terminal.

Looks to me like you have a 7.3 psql talking to a 7.2 server.  Ergo,
you didn't restart the server, or need to point to a different port,
or something like that.

            regards, tom lane

On 03 Apr 2003 16:15:39 -0700, Tom Ansley <tansley@law.du.edu> wrote:
>I just tried upgrading my system from 7.2.3 to 7.3.2
>
>postgres|16:14:40|~> psql sds
>ERROR:  parser: parse error at or near "."
>ERROR:  parser: parse error at or near "."
>Welcome to psql 7.3.2, the PostgreSQL interactive terminal.

This smells like a 7.3 psql talking to a 7.2 postmaster.
Try
sds=> SELECT version();

Servus
 Manfred