call to PostgreSQL function executed twice ?

This is a multi-part message in MIME format.

------_=_NextPart_001_01C71490.FA1C03F8
Content-Type: multipart/alternative;
boundary="----_=_NextPart_002_01C71490.FA1C03F8"


------_=_NextPart_002_01C71490.FA1C03F8
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Hello,
=20
I have an ODBC C-program that executes a call to a PostgreSQL function
called testprocedure.
The call is first prepared, using SQLPrepare(). Next SQLNumResultCols()
and SQLDescribeCol() are used to get information about the result of the
call.
Finally SQLExecute() is called to execute the call to the procedure.
The result now is that two records are inserted into table test, with
other words the PostgreSQL function testprocedure is called twice!
=20
I use the next procedure:
=20
CREATE OR REPLACE FUNCTION testprocedure("varchar") RETURNS void AS $$
BEGIN=20
insert into test values($1);
end;=20
$$
language 'plpgsql';
=20
And the prepared and executed call is "select testProcedure('vib') as
strout"
=20
I use PostgreSQL 8.1.4 on Windows XP professional and ODBC Driver
'PostgreSQL ANSI', version 8.01.02.00 from the PostgreSQL Global
Deveopment Group
=20
It turns out, that SQLNumResultCols() or SQLDescribeCol() also execute
the call. And that the call to SQLExecute() then executes it a second
time.=20
When I leave SQLNumResultCols() out, SQLDescribeCol() will execute the
statement and the other way around.
=20
Is this a bug or do I do something wrong?
From what I understand from the ODBC documentation, only SQLExecute()
should execute a prepared function call.
=20
Thank you,
Jan
=20
Jan Ch. van der Weijde
Senior Software Engineer

=20

=20

Schipholweg 103
2316 XC Leiden
The Netherlands
+31 71 368 1173 phone
+31 71 368 1181 fax
Jan.van.der.Weijde@attachmate.com
www.attachmate.com =20

=20

=20

------_=_NextPart_002_01C71490.FA1C03F8
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable



charset=3Dus-ascii">