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