| From: | John R Pierce <pierce(at)hogranch(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: upgrade from 8.3 to 8.4 |
| Date: | 2011-08-09 02:01:35 |
| Message-ID: | 4E4094FF.8000506@hogranch.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 08/08/11 4:11 PM, Claire Chang wrote:
> I am going to upgrade our PostgresSQL server from 8.3 to 8.4. Is there
> any application code change required? I did some google searches and
> can't find any.
>
to what David already said, I will add this observation...
8.4 is pickier about implied type conversions... if you have code that
assumes it can mix types like text and numeric operations, it may
require adding some explicit type casting, or it will throw errors.
thats the only major thing I've seen that impacts applications.
I assume you know that you need to do a pg_dumpall of your 8.3 data then
load it onto your new 8.4 database cluster, right?
--
john r pierce N 37, W 122
santa cruz ca mid-left coast
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Johnston | 2011-08-09 02:20:18 | Re: Update with ORDER BY and LIMIT |
| Previous Message | Paul M Foster | 2011-08-09 01:58:13 | Re: Update with ORDER BY and LIMIT |