From: Jasen Betts <jasen@xnet.co.nz>
To: pgsql-sql@postgresql.org
Subject: Re: Assigning data-entry tasks to multiple concurrent clients
Date: 1 Jun 2009 08:55:10 GMT
Message-ID: <h0051e$llo$5@reversiblemaps.ath.cx> (raw)
References: <b0a4f3350905312054k515ed999wef6431126a81a02d@mail.gmail.com>
tOn 2009-06-01, Jamie Tufnell <diesql@googlemail.com> wrote:
> --00163646d8e6795c49046b4163e0
> Content-Type: text/plain; charset=ISO-8859-1
> Content-Transfer-Encoding: 7bit
>
> Hi,
>
> I am trying to provide a simple data entry interface to allow multiple
> people to efficiently work through every record in a table and fill in the
> missing values.
>
> The interface is a web application that simply loads up record after record
> until they're all complete.
>
> I want to minimize the possibility of assigning the same record to two
> users.
update records set locked_since = now() where id = (select
id from recored order by locked_since is NOT NULL, locked_since desc
limit 1) returning *
your operators may end up fighting over the last two records,
would that be a bad thing?
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: jasen@xnet.co.nz
Subject: Re: Assigning data-entry tasks to multiple concurrent clients
In-Reply-To: <h0051e$llo$5@reversiblemaps.ath.cx>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox