Query buffer allocate error in copy_statement_with_parameters

From: "John C(dot) Frickson" <john(at)frickson(dot)us>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Query buffer allocate error in copy_statement_with_parameters
Date: 2014-05-22 17:55:19
Message-ID: 1400781319.3209.15.camel@server.frickson.pvt
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

I'm getting the error message "Query buffer allocate error in
copy_statement_with_parameters" when calling a function with a
parameter.

The very simple function was created like this:

CREATE OR REPLACE FUNCTION pvsystem.spclearloginfails
(_seconds integer)
RETURNS void AS $$
BEGIN
DELETE FROM LoginFails WHERE extract(epoch FROM NOW()) -
extract(epoch FROM LastFail) > _seconds;
END;
$$
LANGUAGE 'plpgsql' VOLATILE CALLED ON NULL INPUT
SECURITY DEFINER COST 100;

Calling SQLPrepare() works fine. Calling SQLDescribeParam() works fine.
Calling SQLBindParameter() works fine.
SQLExecute returns the above error.

The data buffer for the parameter is 10 bytes long. The contents are
"300" followed by nulls. length_or_ind is 3.

Doesn't seem like there's very much that can go wrong here.

The server is version 9.2.7 and the ODBC driver is version 08.03.0200.
Running on OpenSUSE 13.1.

Thanks!
John

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Denise McGrath 2014-05-22 23:37:14 126 Error Connecting With psqlODBC 32 bit
Previous Message David Joffe 2014-05-21 20:26:01 Recent ODBC drivers possibly broken on XP - missing msvcrt dll