Re: about serial

On Fri, Nov 14, 2003 at 18:24:16 +0100,
Guillaume Houssay <ghoussay(at)noos(dot)fr> wrote:
> I am using the version 7.3.4
>
> In some tables, I have serial to manage a unique identifier.
>
> As an example I have a column calld id_data as a serial4.
>
> I have in my tables 30 rows with id_data from 1 to 30
>
> Then I delete rows with id 10 and 11.
> Then I vaccum the table.
> I create some new rows and the id_data starts with 10 then 11 and then 12. But the problem is that 12 already exists. So I have 2 rows with the same id_data.
>
> Sorry if my problem is simple but I thought that the serial will keep moving starting at 31 instead of 10.

That is what it should do.

It might be helpful if you show us exactly what you are doing.