Well, All of my editable views have a unique identifier. Navicat does warn you, that it will use an all old = new type of update when you edit.

On 07/11/09 15:53, Dave Page wrote:

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?