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

Reply via email to