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

character varying array bug in 7.4.1

From: "Esh, Andrew" <Andrew_Esh(at)adaptec(dot)com>
To: <pgsql-bugs(at)postgresql(dot)org>
Subject: character varying array bug in 7.4.1
Date: 2004-01-08 18:52:48
Message-ID: B38A3B4F283DBA419282705B57A2425B2E24DF@aime2k02.adaptec.com (view raw or flat)
Thread:
Lists: pgsql-bugs
Could someone tell me if this bug is trivially reproducible or already solved before I do a lot of needless documentation on it?

I upgraded from 7.1beta5 to 7.4.1 recently, and I noticed that many of my character varying arrays were getting a trailing space inserted into their last value. This appears to be the result of white space being misplaced during the INSERT/UPDATE command. If there is a space before the close-curly-brace, it gets appended to the last quoted value. When there is no space between the close-quotes and the close-curly-brace, the correct value is inserted. This behavior did not occur in 7.1beta5.

Here's a test I did to show the problem:

test=> update nametable set names = '{ "arf" }' where id = 1;
UPDATE 1
golem=> select id, names from nametable where id = 1;
 id | names 
----+------------------
  1 | {"arf "}
(1 row)

golem=> update nametable set names = '{"arf"}' where id = 1;
UPDATE 1
golem=> select id, names from nametable where id = 1;
 id | names 
----+------------------
  1 | {arf}
(1 row)

I'll be glad to document this further if needed.

---
Andrew C. Esh                mail:Andrew_Esh[at]adaptec.com
Adaptec, Inc.
2905 Northwest Blvd., Suite 20        763-557-9005 (main)
Plymouth, MN 55441-2644 USA      763-551-6418 (direct)

Responses

pgsql-bugs by date

Next:From: Esh, AndrewDate: 2004-01-08 20:12:45
Subject: Re: character varying array bug in 7.4.1
Previous:From: Seum-Lim GanDate: 2004-01-08 18:05:11
Subject: Re: dyntest.pgc not working in 7.4 ?

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