Hi,
I have pg7.3.1 in my PC and pg7.2.3 in another machine. While i tried psql
pg7.2.3 from pg7.3.1 machine, it reports
ERROR: parser: parse error at or near "."
But still, it established the connection. Then it was found that i was
unable to execute any of the forward slash (\) commands from t
You should connect with the 7.2 tools to 7.2 and with 7.3 ones to 7.3.
I think this messages is caused by the introduction of schemas in 7.3, so the
tables look something like public.your_table_name.
psql-7.3 tries to find the public-schema on 7.2 and this doesn't work since
there is none.
Egon
Not long ago, Bhuvan A proclaimed...
> Then it was found that i was
> unable to execute any of the forward slash (\) commands from that version
> of psql. It reports similar error for every forward slash (\) commands.
Sorry to be nit-picky, but those are "backslashes" not forward slashes. ;-)
-=F
Background:
We have quite large production Postgres 7.2 DB which is out of control in
terms of disk consumption. We made it thru the holiday shopping season,
but it isn't over yet. We have taken the DB down once for a vacuum analyze
but only vacuum'd 2 large tables which took FIVE HOURS WITH
