Re: using database for queuing operations? - Mailing list pgsql-general

From Mark Harrison
Subject Re: using database for queuing operations?
Date
Msg-id 414F3C55.7020007@pixar.com
Whole thread Raw
In response to Re: using database for queuing operations?  (Jeff Amiel <jamiel@istreamimaging.com>)
Responses Re: using database for queuing operations?
List pgsql-general
Jeff Amiel wrote:
> Add a column to the nameq table designating the 'state' of the image.
> Then your logic changes to "select * from nameq where serial = (select
> min(serial) from nameq) and state="UNPROCESSED" (or whatever)
> So you select for update, change the state, then process the
> image....then delete.

Thanks Jeff, I think that will work perfectly for me!

Cheers,
Mark

--
Mark Harrison
Pixar Animation Studios

pgsql-general by date:

Previous
From: Jeff Amiel
Date:
Subject: Re: using database for queuing operations?
Next
From: "Jim C. Nasby"
Date:
Subject: Re: using database for queuing operations?