Postgres Pro
Downloads
Home   >   mailing lists

Thread: parse errors when connecting to remote host

parse errors when connecting to remote host

From
"Cornelia Boenigk"
Date:
Hi everybody

When connecting to a remote host I get some strange parse errors. Here
the output from the console:

$ psql -h hostname -U username
Password:
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

postgr=> \d
ERROR:  parser: parse error at or near "."
postgr=> \l
ERROR:  parser: parse error at or near "("

Other backslash-commands like \x \q \? \r are working as expected.

my version: 7.3.2
version on target host: 7.2.0

Can anybody give some hints what's wrong?

Thanks in advance
Conni

Re: parse errors when connecting to remote host

From
Martijn van Oosterhout
Date:
Version 7.3 psql using pre-7.3 database? You get similar errors with 7.2
psql on 7.0 database (though \d works, just not \df).

On Sat, Jun 07, 2003 at 08:03:47PM +0200, Cornelia Boenigk wrote:
> Hi everybody
>
> When connecting to a remote host I get some strange parse errors. Here
> the output from the console:
>
> $ psql -h hostname -U username
> Password:
> 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
>
> postgr=> \d
> ERROR:  parser: parse error at or near "."
> postgr=> \l
> ERROR:  parser: parse error at or near "("
>
> Other backslash-commands like \x \q \? \r are working as expected.
>
> my version: 7.3.2
> version on target host: 7.2.0
>
> Can anybody give some hints what's wrong?
>
> Thanks in advance
> Conni
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faqs/FAQ.html

--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> "the West won the world not by the superiority of its ideas or values or
> religion but rather by its superiority in applying organized violence.
> Westerners often forget this fact, non-Westerners never do."
>   - Samuel P. Huntington
Attachment

Re: parse errors when connecting to remote host

From
Doug McNaught
Date:
"Cornelia Boenigk" <poppcorn@cornelia-boenigk.de> writes:

> When connecting to a remote host I get some strange parse errors. Here
> the output from the console:

[...]

> my version: 7.3.2
> version on target host: 7.2.0
>
> Can anybody give some hints what's wrong?

Use a version of 'psql' that matches the version on the server
side--mixing versions can cause problems due to changes in the system
catalog format.

-Doug

Re: parse errors when connecting to remote host

From
Richard Huxton
Date:
On Saturday 07 Jun 2003 7:03 pm, Cornelia Boenigk wrote:
> When connecting to a remote host I get some strange parse errors. Here
> the output from the console:
>
> $ psql -h hostname -U username
> Password:
> ERROR:  parser: parse error at or near "."
[snip]
> my version: 7.3.2
> version on target host: 7.2.0

You've just pointed out the problem. I'm guessing it's schema-related. They
were added in 7.3 and so it's probably sending queries like:
  SELECT * FROM pg_catalog.footable...

Looks like you'll either want to ssh to the remote host and use its psql, or
install both versions of the client.

--
  Richard Huxton