> I'm creating a data queue on top of postgres and I'm wondering if I've
> made
> an incorrect assumption about isolation or synchronization or some similar
> issue.
Is there a particular reason why you are not using any of the proven
queuing packages (pgq for example)? Because all the issues seem pretty
general to me, and are solved in those packages.
Tomas