Serial

Ok so i'm posting alot in the forums. Anyway for a change i have another problem ^___^

I have a table that has a field n_gen serial NOT NULL

ermm let me explain. I have 5 records inserted (n_gen = 1, 2, 3, 4, 5)

At a surtain point i DELETE the record 2 and UPDATE the record 5 with the n_gen 2. So now i have 4 records (n_gen = 1, 2 (EX 5), 3, 4) Upto this point i'm ok.

The problem is when i INSERT a new record. It takes the value n_gen = 6 but i need it to take the value 5. It keeps a record of the delete records.

Is there anyway in PostgreSQL i can change it? or another progressive that i can use for n_gen ??

Thanks alot.

Shavonne Wijesinghe