On Thu, Mar 31, 2005 at 11:18:19AM -0800, Rick Roman wrote:
>
> Do I understand correctly that you cannot roll back sequences?
Correct. This is mentioned in the documentation and in the FAQ.
http://www.postgresql.org/docs/8.0/interactive/functions-sequence.html
http://www.postgresql.org/docs/faq
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.rollba
