Re: syntax error at or near ";" at character 41 - Mailing list pgsql-admin

From Ian Lea
Subject Re: syntax error at or near ";" at character 41
Date
Msg-id AANLkTintJ57gpSf3ONThHozJj13XQqBrXi_y9knYaqDf@mail.gmail.com
Whole thread Raw
In response to syntax error at or near ";" at character 41  ("Dan Coleman" <mypiehole@corporatebig.com>)
List 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.

pgsql-admin by date:

Previous
From: "Dan Coleman"
Date:
Subject: syntax error at or near ";" at character 41
Next
From: sharilalipv
Date:
Subject: hanging query