Am Mittwoch, 10. Juli 2002 06:50 schrieb Barry Lind:
> Tom,
>
> No. Restarting the postmaster does not resolve the problem. I am going
> to put the debug build in place and see if I can still reproduce.
>
I've this problem on different machines too (on a daily basis), and restarting the
database has never helped. There are for sure no open transactions when this happens,
and the only way out is to regenerate all tuples:
update tablename set colname=colname; (take whatever column you like). I guess it's
because I've a cron job which is running every minute or so and checks some
conditions, and I guess it is called while vacuum full is running too.
Best regards,
Mario Weilguni
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]