Re: Separate Sessions?? (View data <-> Query tool)

Поиск
Список
Период
Сортировка
От Willy-Bas Loos
Тема Re: Separate Sessions?? (View data <-> Query tool)
Дата
Msg-id 1dd6057e0811280625m37a0d95bk230896326257f4d@mail.gmail.com
обсуждение
Ответ на Re: Separate Sessions?? (View data <-> Query tool)  ("Dave Page" <dpage@pgadmin.org>)
Список pgadmin-support
> *thinks* - I wonder if we can use RETURNING for that now...
How? If there is no RETURNING present in the command...

I'm not sure if this is all possible, but you might:
o  make all editable views editable in pgAdmin as an option (costs performance i guess, maybe some unexpected results if the rules do strange things)
o  if there are on update rules present, allow editing the values. After leaving the row refresh the row.
o  if there are on delete rules present, allow deleting rows. After deleting rows, check if they exist, if so refresh them.
o  if there are on insert rules present.. dang, don't know how to do that. Act the same way you do when inserting in a normal table i guess.

Of course the rule may do something completely unexpected, of which pgAdmin would know nothing. In that case you might have to press the refresh button a lot. Maybe make a guru hint out of that.
But i think that any sensible use would be enabled by this.



--
"Patriotism is the conviction that your country is superior to all others because you were born in it." -- George Bernard Shaw

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