> > begin;
> > select * from getting;
> > vacuum;
> > end;
> Question: Does the following really make sense?
> begin transaction;
> select * from table;
> 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).
In response to
pgsql-hackers by date
|Next:||From: Frank Ridderbusch||Date: 1998-10-06 07:41:31|
|Subject: Portability Issue in src/backend/port/snprintf.c (I think)|
|Previous:||From: Bruce Momjian||Date: 1998-10-06 05:42:44|
|Subject: Re: [HACKERS] select * from ..;vacuum crashes|