Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-odbc by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group