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 |
<div class="gmail_quote">> *thinks* - I wonder if we can use RETURNING for that now...<br /><blockquote class="gmail_quote"style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"></blockquote>How?If there is no RETURNING present in the command...<br /><br />I'm not sure if this is all possible,but you might:<br />o make all editable views editable in pgAdmin as an option (costs performance i guess, maybesome unexpected results if the rules do strange things)<br /> o if there are on update rules present, allow editingthe values. After leaving the row refresh the row.<br />o if there are on delete rules present, allow deleting rows.After deleting rows, check if they exist, if so refresh them.<br /> 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.<br /><br />Of course therule may do something completely unexpected, of which pgAdmin would know nothing. In that case you might have to pressthe refresh button a lot. Maybe make a guru hint out of that.<br /> But i think that any sensible use would be enabledby this. <br /><br /></div><br clear="all" /><br />-- <br />"Patriotism is the conviction that your country is superiorto all others because you were born in it." -- George Bernard Shaw<br />
В списке pgadmin-support по дате отправления: