Panic - Format has changed

From: Glen Eustace <geustace(at)godzone(dot)net(dot)nz>
To: pgsql-general(at)postgresql(dot)org
Subject: Panic - Format has changed
Date: 2002-09-13 20:47:23
Message-ID: 1031950043.29456.1336.camel@agree-6
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

last night we upgraded our primary web server, which included upgrading
postgres to 7.2.1

A rather unexpected change in behaviour has broken one of our
applications.

We have a column containing a varchar array. This used to be displayed
with all the elements quoted, seperated by commas i.e.
{ "a","b","c","d" }

Now, the quotes are only present if the element includes a quote or a
space. i.e.
{ a,"b b",c,d }

This is much more difficult to parse and will involve lots of code
changes in our application. Is there ANY setting I can change that will
result in the data being displayed as before.

--

=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Glen and Rosanne Eustace,
GodZone Internet Services, a division of AGRE Enterprises Ltd.,
P.O. Box 8020, Palmerston North, New Zealand 5301
Ph/Fax: +64 6 357 8168, Mob: +64 21 424 015

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Orr, Steve 2002-09-13 21:37:56 PostgreSQL CLOB Support
Previous Message Michael Zouroudis 2002-09-13 20:41:03 cascading