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
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 |