Re: Edit Data in Query Tool

Поиск
Список
Период
Сортировка
От Rishi Ramraj
Тема Re: Edit Data in Query Tool
Дата
Msg-id CAFrF2nNDcyqNs64Xg47mp-1V2pq32t2wNX=G7kEt8O51cCZSiA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Edit Data in Query Tool  (Dave Page <dpage@pgadmin.org>)
Ответы Re: Edit Data in Query Tool
Список pgadmin-hackers
Дерево обсуждения
I believe the way this sort of thing is done in tools like SQL navigator is, only select queries on individual tables with primary keys are updatable. I'm not sure if this condition is sufficient for updatability however. The tool may also need to reissue the query (or modify it) in order to get primary keys.

Is there a branch I could look at that contains the sql parser?


On Mon, Jan 14, 2013 at 6:01 AM, Dave Page <dpage@pgadmin.org> wrote:
On Sun, Jan 13, 2013 at 7:12 PM, Rishi Ramraj
<thereisnocowlevel@gmail.com> wrote:
> Hello All,
>
> How difficult would it be to include the edit data tool as part of the query
> tool's reporting panel? Ideally I would like to select from a table and then
> edit the results of that select directly; that would drastically improve my
> productivity.

Very difficult at the moment. We'd need a SQL parser in the client to
help try to figure out if the result of a query is something that may
be updatable. There is a patch to add a parsers in the works, but even
with that, it would still be very far from trivial.

--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

В списке pgadmin-hackers по дате отправления:

Предыдущее
От: Dave Page
Дата:
Сообщение: Re: Edit Data in Query Tool
Следующее
От: Dave Page
Дата:
Сообщение: Re: Edit Data in Query Tool