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