Обсуждение: My Sequence does not increment what I expected

Поиск
Список
Период
Сортировка

My Sequence does not increment what I expected

От
"Ezequias Rodrigues da Rocha"
Дата:
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>

Re: My Sequence does not increment what I expected

От
"Obe, Regina"
Дата:
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

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.