Re: [pgadmin-support] Unable to edit views

[Mark Murawski]

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 <ko...@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?