Patch for handling unknown data types in jdbc driver - Mailing list pgsql-patches

From Dave Cramer
Subject Patch for handling unknown data types in jdbc driver
Date
Msg-id 003a01c14c3d$3b162e70$c201a8c0@inspiron
Whole thread Raw
In response to Re: NLS for POSTGRESQL (Russian)  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: Patch for handling unknown data types in jdbc driver  (Bruce Momjian <pgman@candle.pha.pa.us>)
Re: Patch for handling unknown data types in jdbc driver  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-patches
Attached is a patch which deals with

select 'id' as xxx from table

The issue is:

When the driver gets a data type which does not map into the SQL.Types
it attempts to load the object into a java object. Eventually throwing
an exception indicating that the type "unknown" was not found.

Since the backend defaults "unknown" types to text it was suggested that
the jdbc driver do the same.

This patch does just that.

I have tested it on the above select statement as well as a small
program that serializes, and deserializes a class

Dave

Attachment

pgsql-patches by date:

Previous
From: Bradley McLean
Date:
Subject: Patch to make int8 values work inside plpython functions
Next
From: Bruce Momjian
Date:
Subject: Re: Patch to make int8 values work inside plpython functions