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)
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
