sequences and rollback - Mailing list pgsql-bugs

From Rick Roman
Subject sequences and rollback
Date
Msg-id 424C4CFB.60001@cotse.net
Whole thread Raw
Responses Re: sequences and rollback  (Michael Fuhr <mike@fuhr.org>)
List pgsql-bugs
Do I understand correctly that you cannot roll back sequences?

JDBC example:

      connect();
      db.setAutoCommit(false);
      Statement stmt=db.createStatement();
      stmt.executeQuery("select nextval('test_seq')");
     ... other table updates ...
      stmt.close();
      db.rollback();
      db.close();

In this example, the sequence does not roll back. .. other table updates
... do roll back.

pgsql-bugs by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: BUG #1567: can't hide password with pg_autovacuum
Next
From: Michael Fuhr
Date:
Subject: Re: sequences and rollback