Re: Max size for bytea type

On Thu, 1 Feb 2007, Kris Jurka wrote:

> On Mon, 22 Jan 2007, Do, Leon (Leon) wrote:
>
>> Sorry, it is my mistake. It is wrong data type.
>>
>
> Still there is a TODO item here. The driver shouldn't bail out with an
> ArrayIndexOutOfBoundsException. It might be best to fail immediately for a
> getBytes call on something that isn't bytea data. It's conceivable that you
> there is bytea escaped data in a text field, but really, what are the odds
> (and use cases) of that?
>

Checking the code behind this, I see:

AbstractJdbc2ResultSet.java:2150

if (fields[columnIndex - 1].getOID() == Oid.BYTEA)
{
return trimBytes(columnIndex,PGbytea.toBytes(this_row[columnIndex - 1]));
}
else
{
return trimBytes(columnIndex, this_row[columnIndex - 1]);
}

So the check I suggested already exists and I don't understand how you got
this error. Do you still have your test case handy?

Kris Jurka