Re: updatable (J2EE) resultsets

I have not seen this patch applied. Was it rejected for some reason?

Kris Jurka

On Wed, 11 Dec 2002, Kris Jurka wrote:

>
> The following adds support for updateable ResultSets with a mixed case
> table name and column names.
>
> What could really use some work is the parseQuery method in
> org.postgresql.jdbc2.AbstractJdbc2ResultSet. When determining if a
> ResultSet can be updated it does not check that all colums of the result
> set aren't derived columns. The check to make sure it is a single table
> is not particularly good. It fails on things like:
>
> SELECT CURRENT_TIMESTAMP;
> SELECT a AS from FROM t;
> SELECT a FROM t1 LEFT JOIN t2 ON (t1.id=t2.id);
> SELECT a FROM t1 UNION SELECT a FROM t2;
>
> I'm not sure how much this can be improved without building a full blown
> parser into the driver.
>
> On Tue, 10 Dec 2002, Fernando Nasser wrote:
>
> > Dave Cramer wrote:
> > > 1) why do you want to use mixed case columns. Postgres supports them but
> > > not very well.
> > >
> >
> > Dave,
> >
> > Can you be more specific? Don't the PostgreSQL delimited identifiers do
> > the trick?
> >
> > We are already talking about a 7.4 release. is there something that
> > could be done to improve this?
> >
> > Regards,
> > Fernando
> >
> >
> >
> > --
> > Fernando Nasser
> > Red Hat Canada Ltd. E-Mail: fnasser(at)redhat(dot)com
> > 2323 Yonge Street, Suite #300
> > Toronto, Ontario M4P 2C9
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 6: Have you searched our list archives?
> >
> > http://archives.postgresql.org
> >
>