Thread: Error Messages

Error Messages

From

"Hall, Samuel L (Sam)"

Date:

01 August 2013, 15:26:14

<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:

02 August 2013, 06:50:11

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 m

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?