Re: UDT arrays

Hi Radoslaw,

Interesting news about SQLData, Input & Output. That's clearly the way to
go. So I assume you're going to be removing the PGobject from the JDBC
driver in a future release? But I still don't understand whether you are
actually going to plan to implement a combination of UDT and ARRAY, such as

CREATE TYPE composite_type AS (f1 int, f2 text);
CREATE TABLE t (array_of_composites composite_type[]);

This works in Postgres, but is not supported by the JDBC driver... Are you
going to address that as well, in the near future?

Cheers
Lukas

2011/2/9 Radosław Smogura <rsmogura(at)softperience(dot)eu>

> Actully I've done support for Structs, with fixation of metdata bugs for
> those
> types (JDBC spec is not clear, about metadata), but only in binary mode. I
> will, probably, don't give support for text protocol, because I belive
> binary
> protocol is future (but here is ?).
>
> Currently
> 1. I need to give full support for SQLData, Input & Output, as well
> implement
> last type (time with timezone).
> 2. I need do something with DISTINCTS/DOMAINS
>
> Problem is with timestamap with timezone, as on this field backend is
> incompatible with JDBC, so probably driver will need to extend database, or
> I
> need to do some "unsafe" operations or throw exception for some situations.
>
> In both of this I need to do / write full tests for many compilations of
> resultset/arrays/structs.
>
> Some functionality will temporaly go away (eg. updating result sets, arrays
> returning result sets for mulitdimensional array, geometric types, and all
> PG*Objects will be sleeped too).
>
> I want to resolve some serius bugs about resultsets and SQLXML, too, before
> release (this with result set may wait, if only one person found it, and
> not
> even found full problem...), but SQLXML is important as XML is popular
> solution.
>
> Maybe "true" async notifications based on listener pattern will be included
> in
> release.
>
> Have a nice day
>
> Lukas Eder <lukas(dot)eder(at)gmail(dot)com> Tuesday 08 February 2011 00:26:58
> > Hello,
> >
> > I was wondering, is JDBC driver support for the combination of UDT's
> > and arrays planned for the near future? I couldn't find any
> > documentation on the JDBC drivers website.
> >
> > Is there any specific reason (apart from the fact that UDT's and/or
> > ARRAYs are not used often) for this lack of implementation? Clearly,
> > the database itself supports this combination. I can easily insert and
> > select data from a table holding UDT arrays
> >
> > Cheers
> > Lukas
>