When I run commands other than SELECT, I get error messages like this from
Explain
ALTER TABLE sites ALTER COLUMN meters_wgs84 SET NOT NULL;
Query result with 0 rows will be returned.
ERROR: syntax error at or near "ALTER"
LINE 1: ... (ANALYZE off, VERBOSE off, COSTS on, BUFFERS off)ALTER TABL.
I had/have Postgres-9.1-Postgis-2.01 running on Ubuntu 12.04 and it was
working fine. I then installed Posthres-9.3-Postgis 2.1.0. planning to do a
upgrade. Both servers are stopped and I can't get either to run.
Any ideas?