From: | Jean-Christophe Roux <jcxxr(at)yahoo(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | |
Date: | 2006-02-10 17:42:54 |
Message-ID: | 20060210174254.50639.qmail@web35307.mail.mud.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
JC
---------------------------------
What are the most popular cars? Find out at Yahoo! Autos
From | Date | Subject | |
---|---|---|---|
Next Message | Bob Pawley | 2006-02-10 17:43:18 | Re: Tool |
Previous Message | Uwe C. Schroeder | 2006-02-10 17:37:41 | Re: Dropping a database that does not exist |