Peter T Mount wrote:
> 7.1 has the beginings of an UpdateableResultSet. When I can work out how to
> solve a few fundamental problems it shouldn't take long.
> Here's a few questions for people to see if they can figure it out:
> * How to detect what table a column belongs so. Required if the query was a
> join of 2 or more tables.
As I understand the JDBC spec, you are not supposed to be able to update
through a ResultSet unless several criteria are met by the query, including that the
query is over exactly one table (to avoid problems like these). I don't recall if
the other cases are also prohibited, but that would make the problem easier.
> * How to detect if the query was on a view. Do we support updateable view's?
> (not tried it myself).
> * How to detect if a column was a computed value (ie count(*) or col1+col2 etc).
In response to
pgsql-interfaces by date
|Next:||From: Joel Burton||Date: 2001-02-06 22:34:37|
|Subject: Re: Set up ODBC driver for access|
|Previous:||From: Familia Ramírez Ramírez||Date: 2001-02-06 22:02:43|
|Subject: Problems with locking|
pgsql-jdbc by date
|Next:||From: Franck Martin||Date: 2001-02-06 23:26:19|
|Subject: RE: GIS-type databases using PostgreSQL|
|Previous:||From: Bruce Momjian||Date: 2001-02-06 17:53:25|
|Subject: Re: [ADMIN]|