• Cursor positions are not affected by savepoint rollback:
• Script:
  • Creating Table:
    CREATE TABLE T1
    (
    eid numeric(2,0) NOT NULL,
    fname character varying(20),
    lname character varying(30),
    address character varying(100),
    CONSTRAINT pk_t1 PRIMARY KEY (eid)
    
    )
    WITH (
    OIDS=FALSE
    );
    ALTER TABLE T1
    OWNER TO postgres;
  • Inserting Data:
    BEGIN;
    INSERT INTO t1(eid, fname, lname, address)
    VALUES (14, 'Basant','Desai', 'Address 5');
    SAVEPOINT SP1;
    INSERT INTO t1(eid, fname, lname, address)
    VALUES (15, 'Pratap','Singh', 'Address 6');
    ROLLBACK TO SAVEPOINT SP1;
    INSERT INTO t1(eid, fname, lname, address)
    VALUES (16, 'Sanjeeva','Reddy', 'Address 7');
    COMMIT;

Note eid =15 row was not added , but eid14, and eid=16 were successfully added.