Re: buffer overflow in 08.04.0100 und 08.04.0200?

From: Hiroshi Inoue <inoue(at)tpf(dot)co(dot)jp>
To: Jan-Peter Seifert <Jan-Peter(dot)Seifert(at)gmx(dot)de>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: buffer overflow in 08.04.0100 und 08.04.0200?
Date: 2010-01-22 01:25:52
Message-ID: 4B58FEA0.2040901@tpf.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Hi,

Could you send me directly the Mylog output?

regards,
Hiroshi Inoue

Jan-Peter Seifert wrote:
> 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

In response to

Browse pgsql-odbc by date

  From Date Subject
Next Message Raiford 2010-01-22 14:52:13 Re: unixODBC, psqlodbcw.so, and Wine...
Previous Message the6campbells 2010-01-21 22:21:26 Re: unixODBC, psqlodbcw.so, and Wine...