That's correct behavior for postgresql. See the documentation for explanation.
-alex On Wed, 20 Mar 2002, Doug Silver wrote: > 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 > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > > >
