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* Software Engineer Ph: +918087463317 Skype ID: dinesh.kumar432 www.enterprisedb.co <http://www.enterprisedb.com/>m<http://www.enterprisedb.com/> * Follow us on Twitter* @EnterpriseDB Visit EnterpriseDB for tutorials, webinars, whitepapers<http://www.enterprisedb.com/resources-community> and more <http://www.enterprisedb.com/resources-community> On Thu, Aug 1, 2013 at 8:55 PM, Hall, Samuel L (Sam) < sam.h...@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?**** >
