Postgres Pro
Downloads
Home   >   mailing lists

Thread: Error Messages

Error Messages

From
"Hall, Samuel L (Sam)"
Date:
<div class="WordSection1"><p class="MsoNormal">When I run commands other than SELECT, I get error messages like this
fromExplain<p class="MsoNormal"> <p class="MsoNormal">ALTER TABLE sites ALTER COLUMN meters_wgs84 SET NOT NULL;<p
class="MsoNormal">Queryresult with 0 rows will be returned.<p class="MsoNormal"> <p class="MsoNormal">ERROR:  syntax
errorat or near "ALTER"<p class="MsoNormal">LINE 1: ... (ANALYZE off, VERBOSE off, COSTS on, BUFFERS off)ALTER
TABL...<pclass="MsoNormal">                                                        ^<p class="MsoNormal"> <p
class="MsoNormal">**********Error **********<p class="MsoNormal"> <p class="MsoNormal">ERROR: syntax error at or near
"ALTER"<pclass="MsoNormal">SQL state: 42601<p class="MsoNormal">Character: 58<p class="MsoNormal"> <p
class="MsoNormal">Thecommand will execute just fine. Is this normal?</div>

Re: Error Messages

From
Dinesh Kumar
Date:
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.com

Follow 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?