Postgres Pro
Downloads
Home   >   mailing lists

Re: client that supports editing views - Mailing list pgsql-general

From Willy-Bas Loos
Subject Re: client that supports editing views
Date
Msg-id CAHnozTi-5COtAsTGeub7Sv8wKYpJ2MFduPwOWteKyiCjY=9gPw@mail.gmail.com
Whole thread Raw
In response to Re: client that supports editing views  (Adrian Klaver <adrian.klaver@gmail.com>)
Responses Re: client that supports editing views  (Thomas Kellerer <spam_eater@gmx.net>)
List pgsql-general
Tree view
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.klaver@gmail.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/A434C531E37AD442815608A769550D8059425A3E00@EGEXCMB01.oww.root.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.klaver@gmail.com



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

pgsql-general by date:

Previous
From: Sandeep Gupta
Date:
Subject: Re: "Tuple not found error" during Index creation
Next
From: Sandeep Gupta
Date:
Subject: Re: "Tuple not found error" during Index creation