> > actually does work, I can confirm that. Is it violating MVCC maybe ?
>
> Yes :-(. I think you can get away with it if all your transactions that
[snip]
Well, I actually don't want to get away this time :-)
This table is only processed by the queue manager and that uses very
short transactions, basically only atomic insert/update/delete. No long
running transaction will ever touch that table.
So this fits perfectly my queue cleanup needs.
Cheers,
Csaba.
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
