Thread: remove warning

remove warning

From
"Alex Cheung Tin Ka"
Date:
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
 
Regards,
Alex

Re: remove warning

From
Damon Cokenias
Date:
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;