Vincent de Phily <vincent.deph...@mobile-devices.fr> writes: > In case it changes anything, this is the uncut (but still anonimized) > function:
> query = """UPDATE foo SET processing = 't' WHERE id IN > > > (SELECT id FROM foo WHERE processing = 'f' ORDER BY id ASC LIMIT %d > FOR UPDATE) > > RETURNING *""" % (conf_getint('DEFAULT', 'push_count', 5000),) Well, of course this view of things exposes a relevant failure mode you hadn't mentioned: maybe sometimes the conf_getint() call returns something other than 5000? regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general