Skip site navigation (1) Skip section navigation (2)

perl/DBI transaction rollback of sequences

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 (view raw or flat)
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
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~






pgsql-novice by date

Next:From: Josh BerkusDate: 2002-03-20 22:35:46
Subject: Re: [SQL] few admin questions
Previous:From: Tom LaneDate: 2002-03-20 21:43:21
Subject: Re: Estimating Database Disk Space

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group