buffer overflow in 08.04.0100 und 08.04.0200?

From: Jan-Peter Seifert <Jan-Peter(dot)Seifert(at)gmx(dot)de>
To: pgsql-odbc(at)postgresql(dot)org
Subject: buffer overflow in 08.04.0100 und 08.04.0200?
Date: 2010-01-21 18:14:35
Message-ID: 4B58998B.4060101@gmx.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Hello,

we ran into a problem with the new versions of psqlODBC (08.04.0100 and
08.04.0200), which causes a crash.
For example one of our functions that dynamically generates queries does
a 'RAISE NOTICE' of the query string before executing it. Sometimes this
string gets very long and the driver crashes. In the CommLog the string
is cut. The limit seems to be 4095. It somehow seems to be connected to
the global socket size which obviously is 4096?
However, it's strange that 8.3.400 is not crashing although the string
seems to be truncated as well.

We checked it with a function that is simply 'raise noticing' a string
longer than 4100 characters/bytes.

-------------------------------------
CREATE OR REPLACE FUNCTION teststringlength() RETURNS CHAR AS

$BODY$

DECLARE
BEGIN

RAISE NOTICE ' ... more than about 4100 characters ...';

RETURN 'Success';

END;
$BODY$

LANGUAGE 'plpgsql' VOLATILE;
-----------------------------------------------

It gets executed with 'SELECT teststringlength();' within a
psqlODBC-connection that uses the same ODBC data source as the other
psqlODBC-Version. In 08.04.0100 and 08.04.0200 it crashes ... in 8.3.400
it doesn't.
Is there maybe a new parameter that is missing, because we reused the
old data source (I'll check tomorrow)?

Thank you very much for any hints,

Peter

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Raiford 2010-01-21 22:00:36 unixODBC, psqlodbcw.so, and Wine...
Previous Message Hiroshi Inoue 2010-01-17 23:12:09 Re: Linux SQLDriverConnectW fails but SQLDriverConnect works.