Re: My Sequence does not increment what I expected

["Obe, Regina" <robe(dot)dnd(at)cityofboston(dot)gov>]

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(at)postgresql(dot)org [mailto:pgadmin-support-owner(at)postgresql(dot)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

Hi list,

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.