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
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 |