Re: Receiving many more rows than expected - Mailing list pgsql-general

Vincent de Phily <vincent.dephily@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