| 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: | Whole Thread | Raw Message | 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) |