Connecting to a 7.1 DB with 7.3 psql
От | Roland Glenn McIntosh |
---|---|
Тема | Connecting to a 7.1 DB with 7.3 psql |
Дата | |
Msg-id | 5.1.0.14.2.20030314122815.06290b28@lnxmain обсуждение исходный текст |
Ответы |
Re: Connecting to a 7.1 DB with 7.3 psql
|
Список | pgsql-general |
I'm having trouble connecting to a 7.1 database with the 7.3.2 client. It seems that my user privileges are severely restricted. Check out this interaction: ---------------------------------- [demo@trout ~/database_dumps]# psql -Usts -h winnie sts 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 sts=> select version(); version -------------------------------------------------------------- PostgreSQL 7.1.3 on i686-pc-cygwin, compiled by GCC 2.95.3-5 (1 row) sts=> \l ERROR: parser: parse error at or near "(" sts=> ---------------------------------- The version of psql is obviously 7.3.2. I compiled it myself from the SRPMs from postgresql.org on this RedHat 6.2 system(trout). The server is obviously running on cygwin, and I don't suspect that's the problem. What could be happeninghere? User sts owns the database named sts. Connecting with a 7.1 client works fine. I'd appreciate any suggestions! -Roland
В списке pgsql-general по дате отправления: