Обсуждение: 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
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;