Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 041FE9FB9E1 for ; Tue, 3 Apr 2007 06:21:17 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 57859-05 for ; Tue, 3 Apr 2007 06:21:09 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from smtpout09.attiva.biz (smtpout09.attiva.biz [85.37.16.7]) by postgresql.org (Postfix) with ESMTP id DCD759FB9D1 for ; Tue, 3 Apr 2007 06:21:08 -0300 (ADT) Received: from FBCMFE02B12.fbc.local ([192.168.30.89]) by smtpout09.attiva.biz with Microsoft SMTPSVC(6.0.3790.1830); Tue, 3 Apr 2007 11:21:06 +0200 Received: from dream ([88.34.161.130]) by FBCMFE02B12.fbc.local with Microsoft SMTPSVC(6.0.3790.1830); Tue, 3 Apr 2007 11:19:52 +0200 Message-ID: <008301c775d1$4b224420$1102a8c0@dream> Reply-To: "Shavonne Marietta Wijesinghe" From: "Shavonne Marietta Wijesinghe" To: Subject: Serial Date: Tue, 3 Apr 2007 11:20:16 +0200 Organization: Studio FORM MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0080_01C775E2.0E20AE70" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2900.3028 X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2900.3028 X-OriginalArrivalTime: 03 Apr 2007 09:19:52.0321 (UTC) FILETIME=[3C466710:01C775D1] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.119 tagged_above=0 required=5 tests=AWL=0.303, BAYES_40=-0.185, HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200704/18 X-Sequence-Number: 28018 This is a multi-part message in MIME format. ------=_NextPart_000_0080_01C775E2.0E20AE70 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable 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 =3D 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 =3D 1, 2 (EX 5), 3, 4) Upto = this point i'm ok.=20 The problem is when i INSERT a new record. It takes the value n_gen =3D = 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 ------=_NextPart_000_0080_01C775E2.0E20AE70 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Ok so i'm posting alot in the forums. = Anyway for a=20 change i have another problem ^___^
 
I have a table that has a field n_gen serial NOT=20 NULL
 
ermm let me explain. I have 5 records = inserted=20 (n_gen =3D 1, 2, 3, 4, 5)
 
At a surtain point i DELETE the record = 2 and UPDATE=20 the record 5 with the n_gen 2. So now i have 4 records (n_gen =3D 1, 2 = (EX 5), 3,=20 4)  Upto this point i'm ok.
 
The problem is when i INSERT a new = record. It takes=20 the value n_gen =3D 6 but i need it to take the value 5. It keeps a = record of=20 the delete records.
 
Is there anyway in PostgreSQL i can = change it? or=20 another progressive that i can use for n_gen ??
 
Thanks alot.
 
 
Shavonne = Wijesinghe
------=_NextPart_000_0080_01C775E2.0E20AE70--