Skip site navigation (1) Skip section navigation (2)

Re: BUG #3641: Concat fails in update

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "Curt" <kurt(at)net2business(dot)com>,<pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #3641: Concat fails in update
Date: 2007-09-28 16:38:30
Message-ID: 46FCE7B6.EE98.0025.0@wicourts.gov (view raw or flat)
Thread:
Lists: pgsql-bugs
>>> On Fri, Sep 28, 2007 at  8:39 AM, in message
<200709281339(dot)l8SDdIxj002744(at)wwwmaster(dot)postgresql(dot)org>, "Curt"
<kurt(at)net2business(dot)com> wrote: 
 
> UPDATE table content=content || 'constant' where idx=101;
> 
> Content field is overwritten with 'constant'.
 
test=> create temp table t1 (idx int not null primary key, content text);
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "t1_pkey" for table "t1"
CREATE TABLE
test=> insert into t1 values (1, 'one');
INSERT 0 1
test=> update t1 set content = content || ' and a half' where idx = 1;
UPDATE 1
test=> select * from t1;
 idx |    content
-----+----------------
   1 | one and a half
(1 row)

test=> select version();
                                       version
-------------------------------------------------------------------------------------
 PostgreSQL 8.2.4 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.3.3 (SuSE Linux)
(1 row)
 
Please show something similar from your environment.
 
-Kevin
 



In response to

pgsql-bugs by date

Next:From: Arley Wilches MarceloDate: 2007-09-28 16:49:02
Subject: BUG #3642: Tiempos de consultas diferentes
Previous:From: Tom LaneDate: 2007-09-28 15:13:44
Subject: Re: BUG #3640: PANIC: ERRORDATA_STACK_SIZE exceeded

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group