vacuum inside the transaction

From: Ruslan A Dautkhanov <rusland(at)scn(dot)ru>
To: pgsql-bugs(at)postgresql(dot)org
Subject: vacuum inside the transaction
Date: 2004-01-19 03:52:44
Message-ID: 400B548C.7020101@scn.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hello !

I just find out that if i try to use VACUUM inside the transaction
block, than it's fail (VACUUM cannot run inside a transaction block).
Ok, I'll vacuum after transaction, but why commit proceed without errors,
so I can think that my update committed :

isbs=# begin;
BEGIN
isbs=# update priceValues set withtax=false;
UPDATE 4976
isbs=# vacuum priceValues;
ERROR: VACUUM cannot run inside a transaction block
isbs=# end;
COMMIT
isbs=# select distinct withtax from priceValues;
withtax
---------

(1 row)
isbs=# select version();
version
---------------------------------------------------------------------
PostgreSQL 7.4.1 on i386-unknown-freebsd4.7, compiled by GCC 2.95.4
(1 row)

I think if commit not really commit a transaction, it should
return error code. Returning 'commit ok' make some confuse ...

--
best regards,
Ruslan A Dautkhanov rusland(at)scn(dot)ru

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2004-01-19 05:57:23 Re: Problem with initdb
Previous Message Peter Eisentraut 2004-01-18 21:50:04 Re: [patch] INSTALL doc note (was Re: BUG #1051: Cannot remove groups)