Re: 7.3 LOCK TABLE problem

On Mon, 2003-01-27 at 15:21, Chris Gamache wrote:
>     BEGIN;
>     LOCK TABLE queue IN EXCLUSIVE MODE;
>     UPDATE queue
>       set status=$$
>     WHERE id = (SELECT min(id)
>        FROM queue
>        WHERE status=0);

This is unrelated, but note that the sub-select would probably be faster
written as:

SELECT id FROM queue WHERE status = 0 ORDER BY id ASC LIMIT 1;

As this form of the query can use a btree index on "id" if one's
present.

>     SELECT id, data
>     FROM queue
>     WHERE status=$procid;

My Perl's a bit rusty, but AFAICS $procid is undefined. Perhaps 'perl
-w' and "use strict;" would be a good idea?

Cheers,

Neil

--
Neil Conway <neilc@samurai.com> || PGP Key ID: DB3C29FC