client that supports editing views

From: Willy-Bas Loos <willybas(at)gmail(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: client that supports editing views
Date: 2013-12-09 13:36:26
Message-ID: CAHnozTgyJ4Ho5oJi1Z4LQuFtqV0d3_OcFC01-xQ8ixBvBG7dag@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have a database with views that have rules on them, so that users can do
insert/update/delete on their part of the data.
The rules ore "do instead" rules that redirect the edits to the table that
actually holds the data, on which the users have no rights.

This works fine in MS Access (at least versions 2000 and 2010).

Now i've added some functionality, i've added a set of views that show
records that a user is entitled to insert, that she hasn't inserted. The
records in the view show the default values, they could be viewed as
"templates". To create the new record, all the user has to do is edit the
template record. It is then inserted into the corresponding table and
consequently disappears from the template view.

But Access 2010 detects the removal from this "template" view as a
conflict: the user did an update, but "another user" deleted the record :( .

Is there a more lightweight windows GUI client that does updates and
deletes on views?

afaik, pgAdmin doesn't allow it.

Cheers,

WBL

--
"Quality comes from focus and clarity of purpose" -- Mark Shuttleworth

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dinesh Kumar 2013-12-09 13:46:09 Re: pgadmin III query
Previous Message Joek Hondius 2013-12-09 10:39:06 network protocol and compatibility question