From: | Maciej Sieczka <tutey(at)o2(dot)pl> |
---|---|
To: | Richard Huxton <dev(at)archonet(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: how to auto GRANT custom ACL on a new table? |
Date: | 2008-02-26 21:49:22 |
Message-ID: | 47C48962.3000205@o2.pl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Richard Huxton pisze:
> Maciej Sieczka wrote:
>> In PG experts
>> opinion, could/should a PostGIS editing software lock table for
>> writing to prevent concurent editing?
> The application should either:
> 1. Take an advisory lock (see the functions/admin functions chapter) so
> that it can use another table to indicate which parts of the GIS are in
> use.
> 2. Check to see if the data changed while the user was editing but
> before committing (known as "optimistic locking"). Then give the user
> the option to overwrite/rollback.
>
> A last resort would be locking rows or the whole table, since a user
> might click "edit" then go to lunch.
>
> Certainly doing nothing isn't much use if you have multiple users editing.
Thanks Richard!
I've forwarded your remarks to QGIS devs [1].
Maciek
[1]http://www.nabble.com/forum/ViewPost.jtp?post=15699694&framed=y
From | Date | Subject | |
---|---|---|---|
Next Message | Dean Gibson (DB Administrator) | 2008-02-26 21:55:56 | Re: utf8 issue |
Previous Message | Magnus Hagander | 2008-02-26 21:37:12 | Re: win32: how to backup (dump does not work) |