pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
syntax error at or near ";" at character 41
2+ messages / 2 participants
[nested] [flat]

* syntax error at or near ";" at character 41
@ 2010-12-30 23:37  Dan Coleman <mypiehole@corporatebig.com>
  0 siblings, 1 reply; 2+ messages in thread

From: Dan Coleman @ 2010-12-30 23:37 UTC (permalink / raw)
  To: 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?
Thank you.

Dan




^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: syntax error at or near ";" at character 41
@ 2010-12-31 09:10  Ian Lea <ian.lea@gmail.com>
  parent: Dan Coleman <mypiehole@corporatebig.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Ian Lea @ 2010-12-31 09:10 UTC (permalink / raw)
  To: mypiehole@corporatebig.com; +Cc: 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.



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2010-12-31 09:10 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2010-12-30 23:37 syntax error at or near ";" at character 41 Dan Coleman <mypiehole@corporatebig.com>
2010-12-31 09:10 ` Ian Lea <ian.lea@gmail.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox