Problem with backend prepare usin

From: "Wayne Armstrong" <wdarmst(at)bacchus(dot)com(dot)au>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Problem with backend prepare usin
Date: 2003-05-24 13:26:19
Message-ID: 200305241326.h4ODQMbv002011@mail.bacchus.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Hi,
I've been trying to get my app to work using the server side prepare option
in the odbc driver.
I't dies on the first query - with SQLSTATE=07009 - Invalid column number in
DescribeCol. [Native Error=13]]
The query being issued is :-
'select current_user as x, current_timestamp as y, current_database() as z'.
The logs from the server look good :-
2003-05-24 23:15:06 [1541] LOG: query: BEGIN;PREPARE _PLAN1202048 as select
urrent_user as x, current_timestamp as y, current_database() as z;EXECUTE _PLAN
202048
2003-05-24 23:15:06 [1541] LOG: duration: 0.009996 sec
2003-05-24 23:15:06 [1541] LOG: query: COMMIT
2003-05-24 23:15:06 [1541] LOG: duration: 0.001244 sec

Has anyone tried this? got it to work?
Is it really part of this release (compiled from source current from the cvs as
at 2003-05-24)? or should I just ignore it for now?

Regards,
Wayne

In response to

Browse pgsql-odbc by date

  From Date Subject
Next Message Dave Page 2003-05-26 07:58:06 Re: Addition to pgsql-odbc FAQ
Previous Message Fabrizio Mazzoni 2003-05-24 09:23:32 ODBC 703001 crashes IIS