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
