Re: [HACKERS] select * from ..;vacuum crashes
Vadim Mikheev <vadim@krs.ru>
From: Vadim Mikheev <vadim@krs.ru>
To: Taral <taral@mail.utexas.edu>
Cc: t-ishii@sra.co.jp, pgsql-hackers@postgreSQL.org
Date: 1998-10-06T06:51:27Z
Lists: pgsql-hackers
Taral wrote: > > > begin; > > select * from getting; > > vacuum; > > end; > > Question: Does the following really make sense? > > begin transaction; > select * from table; > vacuum; > abort transaction; Using vacuum inside BEGIN/END is Bad Idea!!! MUST be disabled: vacuum uses MANY transaction but CommitTransactionCommand() used by vacuum does nothing inside BEGIN/END (only increments command counter). Vadim