From: | "Merlin Moncure" <merlin(dot)moncure(at)rcsonline(dot)com> |
---|---|
To: | "Peter Eisentraut" <peter_e(at)gmx(dot)net> |
Cc: | <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Roadmap for FE/BE protocol redesign |
Date: | 2003-03-12 18:31:48 |
Message-ID: | 303E00EBDD07B943924382E153890E5433F7FD@cuthbert.rcsinc.local |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Peter Eisentraut writes:
> Dave Page writes:
>
> > 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.
>
> Right. But since you can't really write a literal SQL statement that
does
> an update that refers to a previous query, you are already doing a
fair
> amount of internal magic anyway, so if the meta-data is determined by
> magic as well, that seems consistent.
While this may be true, it is possible to build a client side system
that can do this for you. Views and cursors are great, but they are not
always the best tool for the job.
>
> What you need is an updateable cursor on the server side. It has all
the
> facilities you need, including standardized ways to find out the
> updatability metadata. Please concentrate on that and do not attempt
to
> clutter the wire protocol with data that will not withstand a
throrough
> investigation of semantics.
It's not foolproof and may even be foolhardy, but there are certain
advantages to client-side decision making. A couple of integers or so
for each attribute is not a terribly high price to pay. If a compelling
case can be made that it can be put to good use, why not do it?
Merlin
From | Date | Subject | |
---|---|---|---|
Next Message | Dwayne Miller | 2003-03-12 18:35:26 | Re: Case insensitivity, and option? |
Previous Message | Tom Lane | 2003-03-12 18:21:51 | Re: Roadmap for FE/BE protocol redesign |