Willy-Bas Loos, 09.12.2013 14:36: > 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?
What kind of "GUI" are you thinking of? A GUI focused on running SQL queries or a really something like MS Access where you have custom input forms. Thomas -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general