pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: Shavonne Marietta Wijesinghe <shavonne.marietta@studioform.it>
To: Andrew Sullivan <ajs@crankycanuck.ca>
To: pgsql-sql@postgresql.org
Subject: Re: Update problem.
Date: Tue, 3 Apr 2007 09:13:00 +0200
Message-ID: <002701c775bf$847c9930$1102a8c0@dream> (raw)
References: <00c301c77536$938a32e0$1102a8c0@dream>
	<20070402151726.GA30052@phlogiston.dyndns.org>

Thanks. But to do the UPDATE i have to write each column name (for recrd 4) 
and with its column name (for record 2) which is quite alot to write :P

UPDATE MOD48_00_2007 SET te_cognome= te_cognome, te_paternita= te_paternita 
WHERE N_GEN= 9

so it will be like that? But i have to set each column name = to the column 
name.
And i have to do it for echt field? isn't there any other way..
"I hate writting :P"

And Andrew can explain a bit the setval()

Thanks

Shavonne Wijesinghe

From: "Andrew Sullivan" <ajs@crankycanuck.ca>
To: <pgsql-sql@postgresql.org>
Sent: Monday, April 02, 2007 5:17 PM
Subject: Re: [SQL] Update problem.


> On Mon, Apr 02, 2007 at 04:52:46PM +0200, Shavonne Marietta Wijesinghe 
> wrote:
>> 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
>
> If I understand you correclty, you can do an UPDATE to record 4 to
> record 2, then do a setval() on the sequence.  The setval() is
> tricky, though, because you have the problem that other connections
> could be using it.  I'd lock the table in question while you did all
> this.
>
> A
>
> -- 
> Andrew Sullivan  | ajs@crankycanuck.ca
> Unfortunately reformatting the Internet is a little more painful
> than reformatting your hard drive when it gets out of whack.
> --Scott Morris
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend 

view thread (7+ messages)  latest in thread

Message-ID: <002701c775bf$847c9930$1102a8c0@dream>
Permalink:  ../002701c775bf$847c9930$1102a8c0@dream/
Also on:    postgresql.org/message-id/002701c775bf$847c9930$1102a8c0@dream

copy link · copy postgr.es

reply

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, ajs@crankycanuck.ca
  Subject: Re: Update problem.
  In-Reply-To: <002701c775bf$847c9930$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