Kurt, > I'm in the process of writing an application, and I'm not sure > how to properly solve it. > > I have a table with records in, and they either still need to be > processed or not. Several people will be using the table at the > same time. > > I was thinking about using a select .... for update limit 1, but > the other persons will of course try to select the same record > and wait until that one is released. The locks are held for a > long period of time. > > Is there a way to select a row that is not locked yet?
I'm a bit confused by your question. Could you try explaining it another way, possibly with SQL code examples? -- -Josh Berkus Aglio Database Solutions San Francisco ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
