Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #3641: Concat fails in update - Mailing list pgsql-bugs

From Milen A. Radev
Subject Re: BUG #3641: Concat fails in update
Date
Msg-id fdj0jp$9n9$1@sea.gmane.org
Whole thread Raw
In response to BUG #3641: Concat fails in update  ("Curt" <kurt@net2business.com>)
List pgsql-bugs
Tree view 
Curt написа:
> The following bug has been logged online:
>
> Bug reference:      3641
> Logged by:          Curt
> Email address:      kurt@net2business.com
> PostgreSQL version: 8.1.9-1.el5
> Operating system:   Centos 5
> Description:        Concat fails in update
> Details:
>
> UPDATE table content=content || 'constant' where idx=101;
>
> Content field is overwritten with 'constant'.


Is this the real statement you've used? Because it's not a valid UPDATE
statement - it's missing the 'SET' part before the name of the column.
Could you send the real statement _and_ the error message you've got.


--
Milen A. Radev

pgsql-bugs by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: BUG #3641: Concat fails in update
Next
From: Tom Lane
Date:
Subject: Re: BUG #3640: PANIC: ERRORDATA_STACK_SIZE exceeded