From: Greg Speegle <Greg@10happythings.com>
To: Peter T Mount <peter@retep.org.uk>
Cc: pgsql-jdbc@postgresql.org
Subject: Re: [INTERFACES] Q on JDBC's resultset
Date: Tue, 06 Feb 2001 16:31:13 -0600
Message-ID: <3A807B31.DC58C68A@10happythings.com> (raw)
References: <Pine.GSO.4.21.0102012132230.9884-100000@ural2>
<981454871.3a7fd017dc11f@webmail.retep.org.uk>
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).
Greg Speegle
Baylor University
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: Greg@10happythings.com, peter@retep.org.uk, pgsql-jdbc@postgresql.org
Subject: Re: [INTERFACES] Q on JDBC's resultset
In-Reply-To: <3A807B31.DC58C68A@10happythings.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox