Re: Unable to edit views

[Dave Page <dpage(at)pgadmin(dot)org>]

On 7/11/09, Mark Murawski <kobaz(at)kobaz(dot)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