Re: Parse Errors with prepared query

> Ed Brown wrote:
>
> Thanks for any guidance on the following issue:
>
> I am running PostgreSQL 7.2.1 on redhat, accessing from Windows 2000
> Professional. I installed ODBC psqlodbc-07_02_0001.zip off the web
> site. I have a data upload application written in Delphi which moves
> data from an Access table. I've used it at least ten times with an
> Interbase database, and have run something on the order of half a
> million records through it without apparent errors. It composes a
> statement of the form.
>
>     Insert into <Table> Fields<Field1,Field2,Field3,...> Values
>  (?,?,?,...);
>
> It prepares the statement and then executes it for each record in the
> Access table. On one table with about 33,000 record and twenty-some
> fields it works fine. On another table with 11 fields and about 6,000
> records it fails. It fails to execute the query, and returns an error,
> usually of the form
>     ERROR:  parser: parse error at or near "("

Could you check the server side log(debug mode if possible)
and see what query issued exactly at the error ?

> Also: does anyone know, am I saving any time by using a prepared
> statement?  It appears that the driver is just holding the statement
> and inserting the parameters, then passing to the server. Is that
>  correct?

Yes. Unfortuantely there's no prepare functionality in
PostgreSQL yet and so the psqlodbc driver has little to
do with SQLPrepare.

regards,
Hiroshi Inoue
    http://w2422.nsk.ne.jp/~inoue/