Re: sequence not restarting in a for loop (actually semi-random numbers)

Ivan Sergio Borgonovo <mail(at)webthatworks(dot)it> writes:
> insert into mytop (id,n) select id, nextval('tmp_seq')
> from biglist join mylist on biglist.id=mylist
> order by biglist.something limit 3;

I suspect you are expecting the nextval()s to be done after the LIMIT,
but actually they'll most likely be done before it, ie you're getting
a lot of unintended nextvals happening. Try doing the ORDER BY/LIMIT
in a sub-select.

regards, tom lane