Re: remove warning

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 with the 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;