Postgres Pro
Downloads
Home   >   mailing lists

Problem with backend prepare usin - Mailing list pgsql-odbc

From Wayne Armstrong
Subject Problem with backend prepare usin
Date
Msg-id 200305241326.h4ODQMbv002011@mail.bacchus.com.au
Whole thread Raw
In response to Re: slowness in fetch from the psqlodbc driver  (Jeff Eckermann <jeff_eckermann@yahoo.com>)
List pgsql-odbc
Tree view 
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

pgsql-odbc by date:

Previous
From: Fabrizio Mazzoni
Date:
Subject: ODBC 703001 crashes IIS
Next
From: Fabrizio Mazzoni
Date:
Subject: ODBC 703001 crashes IIS