 | | From: | Dave Bodenstab | | Subject: | psql 8.0.0 rc5 parser error on \dt? | | Date: | Mon, 17 Jan 2005 11:31:00 -0600 |
|
|
 | I built 8.0.0rc5 on FreeBSD 4.8. It built with no errors. I then
tried psql using another host running postgresql 7.1.3 and I get the
goofy error message shown below. Other backslash commands seem to work
(ie. \? \e \q).
$ psql -h host-running-7.1.3 test
Welcome to psql 8.0.0rc5, the PostgreSQL interactive terminal.
Type: \copyright for distribution terms
\h for help with SQL commands
\? for help with psql commands
\g or terminate with semicolon to execute query
\q to quit
test=> \dt
ERROR: parser: parse error at or near "."
test=> \q
$
Just to see if there might be something funny with the flex generated
parser, I ran flex against psqlscan.l; the output was identical to the
original psqlscan.c.
I built postgresql with:
$ pg_config --configure
'--with-template=freebsd' '--with-pam' '--with-openssl' 'CFLAGS= ' 'CPPFLAGS= ' 'LDFLAGS=-L/usr/local/lib'
I have not installed postgresql previously on this system, so it cannot
be picking up anything from a previous install.
A question: where would I go to check if this problem has already
been reported?
Thanks.
Dave Bodenstab
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
|
|
| | From: | Tom Lane | | Subject: | Re: psql 8.0.0 rc5 parser error on \dt? | | Date: | Mon, 17 Jan 2005 13:51:26 -0500 |
|
|
| Dave Bodenstab writes:
> I built 8.0.0rc5 on FreeBSD 4.8. It built with no errors. I then
> tried psql using another host running postgresql 7.1.3 and I get the
> goofy error message shown below.
psql's backslash commands are only guaranteed to work with a server of
the same version. Trying 8.0 against a prehistoric server like that
is going to result in all kinds of oddness. (Look at the actual
queries with -E to see why.)
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
|
|
| | From: | Dave Bodenstab | | Subject: | Re: psql 8.0.0 rc5 parser error on \dt? | | Date: | Tue, 18 Jan 2005 03:43:20 -0600 (CST) |
|
|
| >
> Dave Bodenstab writes:
> > I built 8.0.0rc5 on FreeBSD 4.8. It built with no errors. I then
> > tried psql using another host running postgresql 7.1.3 and I get the
> > goofy error message shown below.
>
> psql's backslash commands are only guaranteed to work with a server of
> the same version. Trying 8.0 against a prehistoric server like that
> is going to result in all kinds of oddness. (Look at the actual
> queries with -E to see why.)
>
That was it, thank you. I've now got 8.0.0rc5 installed and running.
The \dt command of psql works fine.
I wonder if it might be possible to issue an error message that
reflects the incompatible version situation that I encountered.
The message I got led me to believe that there was some sort of
parse error in the input I was typing. Had the error message told
me that the DB versions did not match and that unpredictable results
could occur, I might have figured out the problem myself -- or at
least tried it against 8.0.0rc5 once I got it running.
Anyway, thanks again for your response.
Dave Bodenstab
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
|
|
