Re: client that supports editing views

No, there's no timestamp.
Here's a screenshot of the error in access 2010.
I'll have tot translate it, it's in dutch (and you can't change the
language like you can in ubuntu.. )
It says:
==write conflict==
As you were editing the record, it was changed by another user.
If you save the record, the changes by the other user will be overwritten.

If you want to see the changes made by the other user first, copy the
changes to the Clipboard. After that you can still paste your changes to
the record if you like.

Buttons:
Save record (disabled), Copy to Clipboard, Ignore Changes
--end of error message--

But the option to save the record is disabled, the other 2 buttons do not
enable me to save the record.

Anyway, i don't care much for MS Access, any client will do (that is, if it
costs money, it would be nice if most users own it already or it isn't very
expensive)
I've tried:
* pgAdmin
* MS Access 2010 over ODBC
* LibreOffice.org with the SDBC driver.

Does anyone know of a client that is either smart enough to understand
about rules on views, or transparent enough to let the server handle
everything?

Cheers,

WBL

On Mon, Dec 9, 2013 at 4:16 PM, Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com>wrote:

> 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:
>
> http://www.postgresql.org/message-id/A434C531E37AD442815608A769550D
> 8059425A3E00(at)EGEXCMB01(dot)oww(dot)root(dot)lcl
>
> 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
>

--
"Quality comes from focus and clarity of purpose" -- Mark Shuttleworth