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
forsure 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
runningevery minute or so and checks some conditions, and I guess it is called while vacuum full is running too.
Best regards,Mario Weilguni