Wrong increments of Sequence

From: RPK <rpk(dot)general(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Wrong increments of Sequence
Date: 2007-03-31 08:11:55
Message-ID: 9765151.post@talk.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


I have created a sequence with minimum value=1 and increment=1. But whenever
I enter a record in a table and use nextval('seqstudentmaster') to insert
new studentid, it is incremented by 20. How to set it to increment by 1?
--
View this message in context: http://www.nabble.com/Wrong-increments-of-Sequence-tf3496141.html#a9765151
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ron 2007-03-31 10:19:08 Anyone know where I can get an 8.2.3 binary for ubuntu?
Previous Message Stephen Harris 2007-03-30 22:16:00 Re: Slow sequential scans on one DB but not another; fragmentation?