Serials jumping
| От | Matt A. |
|---|---|
| Тема | Serials jumping |
| Дата | |
| Msg-id | 20050826090150.67833.qmail@web35212.mail.mud.yahoo.com обсуждение |
| Ответы |
Re: Serials jumping
Re: Serials jumping |
| Список | pgsql-general |
I have a serial column on a test box DB. I'm
using "select nextval('some_seq') as id" to insert a
id in sequence. It doesn't return the next value but
at least 4 or so (random) ahead of the current
value. Is this to be expected?
Is this the most efficient way to retreive an id value
for insert a row then insert the resulting row into
the related tables?
Is there a more efficient/proper way? I would like all
my records to increment by 1 if possible. I'd be very
grateful to read your opinion.
Thank you.
____________________________________________________
Start your day with Yahoo! - make it your home page
http://www.yahoo.com/r/hs
В списке pgsql-general по дате отправления: