Problems with the size of a select parameter? - Mailing list pgsql-jdbc

From Dan Robinson
Subject Problems with the size of a select parameter?
Date
Msg-id 3D92333A.7010408@dnai.com
Whole thread Raw
List pgsql-jdbc
Hi,

I'm trying to do the following: with a JDBC call

Statement.executeQuery("select sp_update(val1, val2, val3, val4);

sp_update is a stored procedure.  This all seems to work fine with
PostrgreSQL 7.3 but with 7.2 I get a problem when val4 is ~2k.   With
smaller amounts of data ~1k it works.  I haven't tested to see what the
exact size is that fails yet.

I've searched around to try to find some reference to this issue but
didn't find anything.  If I missed looking someplace please let me know
so I can do so in the future.

Thanks in advance.


pgsql-jdbc by date:

Previous
From: Felipe Schnack
Date:
Subject: error codes
Next
From: Felipe Schnack
Date:
Subject: administering pgsql