From: | Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com> |
---|---|
To: | Willy-Bas Loos <willybas(at)gmail(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: client that supports editing views |
Date: | 2013-12-09 15:16:49 |
Message-ID: | 52A5DEE1.3020104@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 12/09/2013 05:36 AM, Willy-Bas Loos wrote:
> 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 timestamp field in the view? This sounds like an issue Access
has with timestamp precision, where if you supply a timestamp that is
too precise it has problems. See here for more detail:
Short version, make your timestamp field timestamp(0).
>
> 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
--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Steve.Toutant | 2013-12-09 15:54:05 | Re: query creates a huge toast tables |
Previous Message | Rémi Cura | 2013-12-09 15:03:05 | Re: Set returning aggregate? |