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