Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 9E5C69FB72D for ; Mon, 2 Apr 2007 11:05:54 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 31101-10 for ; Mon, 2 Apr 2007 11:05:44 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from smtpout27.attiva.biz (smtpout27.attiva.biz [85.37.16.28]) by postgresql.org (Postfix) with ESMTP id 8926D9FB6C8 for ; Mon, 2 Apr 2007 11:05:44 -0300 (ADT) Received: from FBCMFE02B15.fbc.local ([192.168.30.161]) by smtpout27.attiva.biz with Microsoft SMTPSVC(6.0.3790.1830); Mon, 2 Apr 2007 16:05:41 +0200 Received: from dream ([88.34.161.130]) by FBCMFE02B15.fbc.local with Microsoft SMTPSVC(6.0.3790.1830); Mon, 2 Apr 2007 16:05:40 +0200 Message-ID: <008201c77530$0d877690$1102a8c0@dream> Reply-To: "Shavonne Marietta Wijesinghe" From: "Shavonne Marietta Wijesinghe" To: Subject: Update problem. Date: Mon, 2 Apr 2007 16:06:04 +0200 Organization: Studio FORM MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_007F_01C77540.D0AC2D90" 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: 02 Apr 2007 14:05:40.0687 (UTC) FILETIME=[FF15A5F0:01C7752F] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.575 tagged_above=0 required=5 tests=AWL=0.077, BAYES_50=0.001, HTML_40_50=0.496, HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200704/7 X-Sequence-Number: 28007 This is a multi-part message in MIME format. ------=_NextPart_000_007F_01C77540.D0AC2D90 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hello I have a table created as the following CREATE TABLE mod48_00_2007 ( id text, n_gen serial NOT NULL, formstore text, te_cognome text, te_paternita text, te_nome text, te_sesso text, te_dtnasc text, te_attnasc text, te_luonasc text, te_provstato text, te_indi text, te_prov text, te_richiesta text, atto_forma text, rev_test text, atto_dt text, atto_num text, dt_olog text, cod_notaio text, pa_cognome text, pa_nome text, pa_qual text, pa_indirizzo text, pa_civ text, pa_cap text, pa_pro text, pa_sede text, pa_estero text, pa_data text, f_olo text, f_pub text, f_rev text, f_seg text, f_spe text, atto_riferimento text, ratto_dt text, ratto_num text, rdt_olog text, r_cognome text, r_nome text, r_qual text, r_sede text, r_estero text, dt_oggi text, n_pub_aut text, dt_tr_rgt text, sche_singola text, sche_multipla text, n_fog text, tot_n_fog text, reg_anno text, username text, date_inserted text, time_inserted text, deleted text, date_deleted text, time_deleted text, f_tes text, CONSTRAINT mod48_00_2007_pkey PRIMARY KEY (n_gen) )=20 At a surtain point i need to replace a record with another For example i have inserted 4 records. (1, 2 , 3 , 4) I need to replace = all the values from the record 4 to the record 2 but keeping the n_gen = serial key. And then delete the record 4. So that the next record i = insert will take the n_gen 4 How can i do this? Shavonne Wijesinghe www.studioform.it =20 Le informazioni contenute nella presente comunicazione e i relativi = allegati possono essere riservate e sono, comunque destinate = esclusivamente alle persone o alla Societ=E0 sopra indicati. La diffusione, distribuzione e/o copiature del documento trasmesso da = parte di qualsiasi soggetto diverso dal destinatario =E8 proibita, sia = ai sensi dell'art. 616 c.p., che ai sensi del D. Lgs. n. 196/2003. =20 Se avete ricevuto questo messaggio per errore, Vi preghiamo di = distruggerlo e di informarci immediatamente per telefono allo = 0039362595044 o inviando un messaggio all'indirizzo e-mail amministrazione@studioform.it =20 The informations in this communication is confidential and may also be = legally privileged. It is intended for the addressee only. Access to this e-mail by anyone else is unauthorized. It is not to be = relied upon by any person other than the addressee, except with our = prior written approval. If you received this message please send an = e-mail to the sender. ------=_NextPart_000_007F_01C77540.D0AC2D90 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hello
 
I have a table created as the=20 following
 
CREATE TABLE = mod48_00_2007
(
  id text,
  n_gen serial NOT = NULL,
 =20 formstore text,
  te_cognome text,
  te_paternita=20 text,
  te_nome text,
  te_sesso text,
  = te_dtnasc=20 text,
  te_attnasc text,
  te_luonasc text,
 =20 te_provstato text,
  te_indi text,
  te_prov = text,
 =20 te_richiesta text,
  atto_forma text,
  rev_test = text,
 =20 atto_dt text,
  atto_num text,
  dt_olog text,
  = cod_notaio text,
  pa_cognome text,
  pa_nome = text,
 =20 pa_qual text,
  pa_indirizzo text,
  pa_civ = text,
 =20 pa_cap text,
  pa_pro text,
  pa_sede text,
  = pa_estero=20 text,
  pa_data text,
  f_olo text,
  f_pub=20 text,
  f_rev text,
  f_seg text,
  f_spe=20 text,
  atto_riferimento text,
  ratto_dt = text,
 =20 ratto_num text,
  rdt_olog text,
  r_cognome = text,
 =20 r_nome text,
  r_qual text,
  r_sede text,
  = r_estero=20 text,
  dt_oggi text,
  n_pub_aut text,
  = dt_tr_rgt=20 text,
  sche_singola text,
  sche_multipla = text,
  n_fog=20 text,
  tot_n_fog text,
  reg_anno text,
  = username=20 text,
  date_inserted text,
  time_inserted = text,
 =20 deleted text,
  date_deleted text,
  time_deleted=20 text,
  f_tes text,
  CONSTRAINT mod48_00_2007_pkey = PRIMARY KEY=20 (n_gen)
)
 
At a surtain point i need to replace a = record with=20 another
 
For example i have inserted 4 records.=20 (1, 2 , =20 3 , 4) I need to=20 replace all the values from the record 4 to the record 2 but keeping the = n_gen serial key. And then = delete the=20 record 4. So that the next record i insert will take the n_gen=20 4
 
How can i do this?
 
Shavonne Wijesinghe
www.studioform.it
 
Le=20 informazioni contenute nella presente comunicazione e i relativi = allegati=20 possono essere riservate e sono, comunque destinate esclusivamente alle = persone=20 o alla Societ=E0 sopra indicati.
La diffusione, distribuzione e/o = copiature del=20 documento trasmesso da parte di qualsiasi soggetto diverso dal = destinatario =E8=20 proibita, sia ai sensi dell=92art. 616 c.p., che ai sensi del D. Lgs. n. = 196/2003.
 
Se avete ricevuto questo messaggio per errore, Vi = preghiamo di distruggerlo e di informarci immediatamente per telefono = allo=20 0039362595044 o inviando un messaggio all=92indirizzo e-mail
amministrazione@studioform.= it
 
The=20 informations in this communication is confidential and may also be = legally=20 privileged. It is intended for the addressee only.
Access to this = e-mail by=20 anyone else is unauthorized. It is not to be relied upon by any person = other=20 than the addressee, except with our prior written approval. If you = received this=20 message please send an e-mail to the sender.
------=_NextPart_000_007F_01C77540.D0AC2D90--