From: Shavonne Marietta Wijesinghe <shavonne.marietta@studioform.it>
To: pgsql-sql@postgresql.org
Subject: Serial
Date: Tue, 3 Apr 2007 11:20:16 +0200
Message-ID: <008301c775d1$4b224420$1102a8c0@dream> (raw)
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 instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: shavonne.marietta@studioform.it
Subject: Re: Serial
In-Reply-To: <008301c775d1$4b224420$1102a8c0@dream>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox