At 11:59 AM +0800 4/15/02, Alex Cheung Tin Ka wrote:
>Dear All,
> I am using pgsql 7.2. The server always generate following warning message:
> NOTICE: ROLLBACK: no transaction in progress
>
> I would like to know how to get rid of such messages
This message indicates a problem with your query. You can only use the ROLLBACK command after starting a transaction
withthe BEGIN command.
Example:
good:
BEGIN
DELETE FROM table;
ROLLBACK;
bad:
DELETE FROM table;
ROLLBACK;
bad:
BEGIN;
DELETE FROM table;
COMMIT;
ROLLBACK;
bad:
BEGIN;
DELETE FROM table;
ROLLBACK;
ROLLBACK;