client that supports editing views

Поиск
Список
Период
Сортировка
От Willy-Bas Loos
Тема client that supports editing views
Дата
Msg-id CAHnozTgyJ4Ho5oJi1Z4LQuFtqV0d3_OcFC01-xQ8ixBvBG7dag@mail.gmail.com
обсуждение исходный текст
Ответы Re: client that supports editing views
Re: client that supports editing views
Список 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

В списке pgsql-general по дате отправления: