psql 8.0.0 rc5 parser error on \dt?

Started by Dave Bodenstababout 21 years ago3 messagesbugs
Jump to latest
#1Dave Bodenstab
dave@bodenstab.org

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

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Dave Bodenstab (#1)
Re: psql 8.0.0 rc5 parser error on \dt?

Dave Bodenstab <dave@bodenstab.org> 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

#3Dave Bodenstab
dave@bodenstab.org
In reply to: Tom Lane (#2)
Re: psql 8.0.0 rc5 parser error on \dt?

Dave Bodenstab <dave@bodenstab.org> 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