Re: Unable to edit views

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 />