Thread: My Sequence does not increment what I expected
Hi list,<br /><br />I have a sequence and when I insert a new row the sequence increment 101 instead of 1.<br /><br />Doesanybody noticed something like that ? Should I delete and recreate the sequence ?<br /><br /><br />Any help will bewelcomed. <br /><br /><br />Regards ...<br clear="all" /><br />-- <br /> =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-<br /> Atenciosamente(Sincerely)<br /> Ezequias Rodrigues da Rocha <br/> =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-<br />A pior das democracias ainda é melhordo que a melhor das ditaduras<br />The worst of democracies is still better than the better of dictatorships <br /><ahref="http://ezequiasrocha.blogspot.com/">http://ezequiasrocha.blogspot.com/</a>
You maybe had added data before and then deleted it. You can go in and change the sequence start number via pgAdmin by expanding the sequences node, selecting the sequence in question and changing the current value to 1 and minimum to 1.
From: pgadmin-support-owner@postgresql.org [mailto:pgadmin-support-owner@postgresql.org] On Behalf Of Ezequias Rodrigues da Rocha
Sent: Friday, September 29, 2006 8:02 AM
To: pgAdmin Support
Subject: [pgadmin-support] My Sequence does not increment what I expected
I have a sequence and when I insert a new row the sequence increment 101 instead of 1.
Does anybody noticed something like that ? Should I delete and recreate the sequence ?
Any help will be welcomed.
Regards ...
--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Atenciosamente (Sincerely)
Ezequias Rodrigues da Rocha
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
A pior das democracias ainda é melhor do que a melhor das ditaduras
The worst of democracies is still better than the better of dictatorships
http://ezequiasrocha.blogspot..com/
The substance of this message, including any attachments, may be
confidential, legally
privileged and/or exempt from disclosure pursuant to Massachusetts
law. It is intended
solely for the addressee. If you received this in error, please
contact the sender and
delete the material from any computer.