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]