ROLLBACK problem

Kshipra wrote:

Hello,
We are in the process of evaluating PostgreSQL ,
we could not perform ROLLBACK function in pgsql .
It got aborted .
Tell us how ROLLBACK is to be executed.
thanks

CREATE TABLE test (
aval text
);

INSERT INTO test
VALUES ( 'a' );

INSERT INTO test
VALUES ( 'b' );

INSERT INTO test
VALUES ( 'c' );

SELECT * FROM test;

aval
------
a
b
c

BEGIN;

INSERT INTO test
VALUES ( 'd' );

INSERT INTO test
VALUES ( 'e' );

ROLLBACK;

SELECT * FROM test;

aval
------
a
b
c

________________________
Ron Peterson
rpeterson@yellowbank.com