Обсуждение: Unable to edit views
<font size="+1">Feature request: Editing of editable views<br /><br /> When you view the data on a view, nothing is editable. Navicat in windows supports editing editable views by using an 'update where all columns = old data, set new data'type of query.<br /><br /> My projects heavily use editable views, and I'm constantly switching between pgadmin andnavicat.<br /><br /><br /></font>
On 7/11/09, Mark Murawski <kobaz@kobaz.net> wrote: > Feature request: Editing of editable views > > When you view the data on a view, nothing is editable. Navicat in windows > supports editing editable views by using an 'update where all columns = old > data, set new data' type of query. Yikes, thats pretty broken (and one of the reasons pgAdmin doesn't support updateable view editting). > My projects heavily use editable views, and I'm constantly switching between > pgadmin and navicat. What happens in Navicat if the update rule updates something other than what you thought you were editting? -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com
Well, All of my editable views have a unique identifier. Navicat does warn you, that it will use an all old = new typeof update when you edit.<br /><br /><br /><br /> On 07/11/09 15:53, Dave Page wrote: <blockquote cite="mid:937d27e10907111253s3f16a2f0w381ff56b1b04758f@mail.gmail.com"type="cite"><pre wrap="">On 7/11/09, Mark Murawski<a class="moz-txt-link-rfc2396E" href="mailto:kobaz@kobaz.net"><kobaz@kobaz.net></a> wrote: </pre><blockquotetype="cite"><pre wrap="">Feature request: Editing of editable views When you view the data on a view, nothing is editable. Navicat in windows supports editing editable views by using an 'update where all columns = old data, set new data' type of query. </pre></blockquote><pre wrap=""> Yikes, thats pretty broken (and one of the reasons pgAdmin doesn't support updateable view editting). </pre><blockquote type="cite"><pre wrap="">My projects heavily use editable views, and I'm constantly switching between pgadmin and navicat. </pre></blockquote><pre wrap=""> What happens in Navicat if the update rule updates something other than what you thought you were editting? </pre></blockquote><br />
It would be really really great if when you added a new server, or changed local settings, that it wrote out the config file. When pgadmin crashes, you lose any settings changes.