Re: 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*
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(dot)hall(at)alcatel-lucent(dot)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?****
>