Re: Problems on inserting with DBD::Pg

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Simon Crute" <simon-news(at)nospam(dot)geordie(dot)demon(dot)co(dot)uk>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Problems on inserting with DBD::Pg
Date: 2001-05-11 15:13:55
Message-ID: 4733.989594035@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Simon Crute" <simon-news(at)nospam(dot)geordie(dot)demon(dot)co(dot)uk> writes:
> The error message reported is
> [Tue May 8 20:25:27 2001] newuser.plx: DBD::Pg::st execute failed: ERROR:
> parser: parse error at or near "ail" at /......./cgi/newuser.plx line 161.

Suggested approach to problems like this: turn on query logging at the
postmaster, so you can see exactly what query string is being
constructed and sent to the server. Then you can usually work out what
went wrong.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Joseph 2001-05-11 15:27:16 single quotes in a select statement
Previous Message Thomas F. O'Connell 2001-05-11 14:56:39 Re: How to create a trigger