From: | Doug Silver <dsilver(at)quantified(dot)com> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | perl/DBI transaction rollback of sequences |
Date: | 2002-03-20 22:14:08 |
Message-ID: | Pine.LNX.4.21.0203201411240.19690-100000@danzig.sd.quantified.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Hi All -
Sorry if this isn't the right list, but I'm hoping someone might have some
insight into this.
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, DBD-Pg-1.01, and postgresql-7.1.3.
Thanks!
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Doug Silver
Network Manager
Quantified Systems, Inc
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From | Date | Subject | |
---|---|---|---|
Next Message | Josh Berkus | 2002-03-20 22:35:46 | Re: [SQL] few admin questions |
Previous Message | Tom Lane | 2002-03-20 21:43:21 | Re: Estimating Database Disk Space |