| From: | Scott Marlowe <smarlowe(at)g2switchworks(dot)com> |
|---|---|
| To: | Jean-Christophe Roux <jcxxr(at)yahoo(dot)com> |
| Cc: | pgsql general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Sequence skipping values |
| Date: | 2006-02-10 17:53:33 |
| Message-ID: | 1139594013.22740.137.camel@state.g2switchworks.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Fri, 2006-02-10 at 11:44, Jean-Christophe Roux wrote:
> Hello,
> I have a table with and id field (primary key) which default value is
> the result of a sequence (increment explicitly set to 1).
> To my surprise, the real increment on insert is the total number of
> rows of the table. For instance, with 41 rows and a sequence
> last_value of 1141, the next insert row will have a value of 1182. It
> is not a big problem but I don't like skipping and wasting values in a
> sequence. Also, I'd like to understand what's going on!
> If someone could give me a clue that wold be greatly appreciated
> thanks
Have you got some kind of trigger or rule on this table that could be
causing such behaviour?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Steve Crawford | 2006-02-10 17:57:31 | Re: Sequence skipping values |
| Previous Message | Csaba Nagy | 2006-02-10 17:50:13 | Re: Sequence skipping values |