Обсуждение: Error Messages
Hi,
The ERROR message what have got is from PG database and it's not from the pgAdmin.
It's an expected result. I believe, EXPLAIN ANALYZE only supports DML/Select queries.
Dinesh
--
Dinesh Kumar
.jpg)
Ph: +918087463317
Follow us on Twitter
@EnterpriseDB
Visit EnterpriseDB for tutorials, webinars, whitepapers and more
--
Dinesh Kumar
Software Engineer
Ph: +918087463317
Skype ID: dinesh.kumar432
www.enterprisedb.comFollow us on Twitter
@EnterpriseDB
Visit EnterpriseDB for tutorials, webinars, whitepapers and more
On Thu, Aug 1, 2013 at 8:55 PM, Hall, Samuel L (Sam) <sam.hall@alcatel-lucent.com> wrote:
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?