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

Reply via email to