Thread: Problem connecting to psql

Problem connecting to psql

From
Richard Nairn
Date:
I am trying to connect remotely to my database and I am getting an error:

ERROR: parser: parse error at or near "."
Welcome to psql 7.3.2 ...

I can run queries, but I can't use some of the built in functions such as
\d \l.

My backend is 7.2. Is this a problem? I am planning on upgrading to 7.4.

Thanks for your help


--
  |       Richard Nairn          Specializing in Linux
  |     Nairn Consulting         Web / Database Solutions
  |        Calgary, AB
  | Richard@NairnConsulting.ca

Re: Problem connecting to psql

From
Tom Lane
Date:
Richard Nairn <Richard@nairnconsulting.ca> writes:
> I can run queries, but I can't use some of the built in functions such as
> \d \l.

psql's backslash commands generally assume the server is of the same
major version as psql.  7.3.2 to 7.2 won't work.

            regards, tom lane

Re: Problem connecting to psql

From
Richard Nairn
Date:
Thanks for the reply. I'll take care to keep the same version around. So
there is no type of compatibility mode? Feature request maybe?

On Thu, 11 Dec 2003 11:12:37 -0500, Tom Lane <tgl@sss.pgh.pa.us> wrote:

> Richard Nairn <Richard@nairnconsulting.ca> writes:
>> I can run queries, but I can't use some of the built in functions such
>> as
>> \d \l.
>
> psql's backslash commands generally assume the server is of the same
> major version as psql.  7.3.2 to 7.2 won't work.
>
>             regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
>                http://www.postgresql.org/docs/faqs/FAQ.html



--
|       Richard Nairn          Specializing in Linux
|     Nairn Consulting         Web / Database Solutions
|        Calgary, AB
  | Richard@NairnConsulting.ca