Обсуждение:

Поиск
Список
Период
Сортировка

От
"Mary O'Donovan"
Дата:

Hello I am running cygwin and Windows XP and get the following error.

$ /usr/bin/psql -x  -E -l

********* QUERY **********

SELECT d.datname as "Name",

       u.usename as "Owner",

       pg_catalog.pg_encoding_to_char(d.encoding) as "Encoding"

FROM pg_catalog.pg_database d

  LEFT JOIN pg_catalog.pg_user u ON d.datdba = u.usesysid

ORDER BY 1;

**************************

 

ERROR:  parser: parse error at or near "("

 

$ /usr/bin/psql -V

psql (PostgreSQL) 7.4.1

contains support for command-line editing

 

$ initdb -V

initdb (PostgreSQL) 7.4.1

 

I can get into psql but any command such as \dt etc also results in parse error.

 

Any help would be appreciated,

Rgds,

Mary.

Re:

От
Peter Eisentraut
Дата:
Mary O'Donovan wrote:
> Hello I am running cygwin and Windows XP and get the following error.
>
> $ /usr/bin/psql -x  -E -l
>
> ********* QUERY **********
>
> SELECT d.datname as "Name",
>
>        u.usename as "Owner",
>
>        pg_catalog.pg_encoding_to_char(d.encoding) as "Encoding"
>
> FROM pg_catalog.pg_database d
>
>   LEFT JOIN pg_catalog.pg_user u ON d.datdba = u.usesysid
>
> ORDER BY 1;
>
> **************************
>
>
>
> ERROR:  parser: parse error at or near "("

Maybe you are connected to an older server.