| From: | "Hall, Samuel L (Sam)" <sam(dot)hall(at)alcatel-lucent(dot)com> |
|---|---|
| To: | "pgadmin-support(at)postgresql(dot)org" <pgadmin-support(at)postgresql(dot)org> |
| Subject: | Error Messages |
| Date: | 2013-08-01 15:25:49 |
| Message-ID: | 69751890A64B3241A83BDB52A30BF29D0E057F@US70UWXCHMBA05.zam.alcatel-lucent.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgadmin-support |
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...
^
********** Error **********
ERROR: syntax error at or near "ALTER"
SQL state: 42601
Character: 58
The command will execute just fine. Is this normal?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bill MacArthur | 2013-08-01 22:40:18 | v 1.16.1 incorrectly displays the properties of a FDW table |
| Previous Message | David Johnston | 2013-08-01 14:11:33 | Re: How to enter daterange into a raw? - SOLVED |