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