Hi All - I'm just trying to confirm the perl DBI transaction/rollback feature, which works as expected except for one thing, one field that is SERIAL keeps incrementing, i.e. the sequence doesn't get rolled back. Does this mean I need to manually rollback (setval (current value-1))??
I tried both automatically inserting into the table and manually getting the next value, but it doesn't matter. I'm using perl 5.6, DBI-1.20, and DBD-Pg-1.01 (PostgreSQL). Thanks! (Please cc me directly as I'm not on this list) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Doug Silver Network Manager Quantified Systems, Inc ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
