Re: Roadmap for FE/BE protocol redesign

> -----Original Message-----
> From: Peter Eisentraut [mailto:peter_e@gmx.net] 
> Sent: 12 March 2003 00:34
> To: Dave Page
> Cc: Tom Lane; PostgreSQL Development
> Subject: Re: [HACKERS] Roadmap for FE/BE protocol redesign
> 
> 
> Dave Page writes:
> 
> > I don't know about JDBC, but ODBC could use it, and it would save a 
> > heck of a lot of pain in apps like pgAdmin that need to 
> figure out if 
> > a column in an arbitrary resultset might be updateable.
> 
> Strictly speaking, result sets are never updatable, because 
> there's no way you can refer to a result set and tell the 
> system to update it.  So let's hear what you *really* need 
> and then consider interfaces for *that*. Maybe updatable 
> views or updatable cursors?

Well what I *really* need has been made quite clear in other posts, but,
when I say resultset in the same sentence as pgAdmin, I'm referring to
the ability to enter an arbitrary SQL query, have the results displayed
in a grid, which can then be editted. To do this pgAdmin needs to be
able to figure out enough info about the source of the data to generate
the required insert/update/delete statements.

It also happens that ODBC, JDBC etc, also need the same information to
meet their specs.

Regards, Dave.