Re: syntax error at or near ";" at character 41

From: Ian Lea <ian(dot)lea(at)gmail(dot)com>
To: mypiehole(at)corporatebig(dot)com
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: syntax error at or near ";" at character 41
Date: 2010-12-31 09:10:53
Message-ID: AANLkTintJ57gpSf3ONThHozJj13XQqBrXi_y9knYaqDf@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

> I really hope someone can help me with this. All of a sudden this error
> is filling my postgres log. I restart Postgres and somewhere around a
> minute or two these start getting issued. I have been running this system
> for a long time and no changes have been made. Anyone have an idea where
> i can look?

Sounds like something is firing some invalid SQL at your database.
I'd expect the offending SQL to be logged as well but maybe you'll
need to play with the log settings. log_statement = 'all' will log
all statements.

--
Ian.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message kirancnair 2011-01-03 06:55:30 Greenplum: Functions that execute SQL statements from the segDBs are not yet supported.
Previous Message Dan Coleman 2010-12-30 23:37:27 syntax error at or near ";" at character 41