|
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 [EMAIL PROTECTED] |
smime.p7s
Description: S/MIME Cryptographic Signature
