Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group