Re: error during vacuum full

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