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 по дате отправления: