Hannes Dorbath wrote:
> Hannes Dorbath wrote:
>> Yes, I'll try to catch the row.
>
> I just slammed a BEFORE UPDATE FOR EACH ROW trigger with RAISE NOTICE on
> the table to catch the row ID where it fails.
>
> The row ID is never the same. Neither can I reproduce it when I use the
> last reported row ID.
>
> Is NOTICE logging / printing asynchron? Is there some sort of queuing that
> eats the ID where it really fails?
>
> Any ideas to track this down?
Turn off autovacuum and see if it makes any difference.
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support