From: | slane <slane(at)moyergroup(dot)com> |
---|---|
To: | <pgsql-admin(at)postgresql(dot)org> |
Cc: | Jamie Thomas <jthomas(at)soliantconsulting(dot)com> |
Subject: | PG 7.2 varchar change |
Date: | 2004-08-13 03:30:14 |
Message-ID: | BD419FF6.1880F%slane@moyergroup.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hello all:
I am upgrading a web application from postgres 7.1.2 to 7.4.3 (too long in
coming to that point, I know).
I have sifted through the history files and identified a restricted number
of changes that potentially impact the app, a few of which I don¹t
understand.
Here¹s the currently most alarming, a change that is recorded for 7.2:
CHAR(), VARCHAR() now reject strings that are too long (Peter E)
What does this mean? Or how do I find out what it means? My understanding
was that varchar fields had no text limit. But these are written like
functions. Does this refer to coercion functions that now reject strings
that are longer than the specified size of the underlying column? What if
the column was specified as type text¹? And what was the old behavior?
Thanks for any insight. This is the only change that¹s really concerning us
deeply right now.
-- sgl
=======================================================
Steve Lane
Vice President
Soliant Consulting
14 North Peoria St Suite 2H
Chicago, IL 60607
voice: (312) 850-3930 email: slane(at)soliantconsulting(dot)com
fax: (312) 850-3930 web: http://www.soliantconsulting.com
=======================================================
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2004-08-13 03:57:11 | Re: PG 7.2 varchar change |
Previous Message | Mohammad Tanvir Huda | 2004-08-13 01:29:27 | Re: Connecting Postgres using other network |