From: | Mark Morgan Lloyd <markMLl(dot)pgsql-general(at)telemetry(dot)co(dot)uk> |
---|---|
To: | pgsql-general(at)PostgreSQL(dot)org |
Subject: | Re: Updating from 8.2 to 8.4 |
Date: | 2009-12-26 13:01:44 |
Message-ID: | hh51fq$o8g$1@pye-srv-01.telemetry.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Adrian Klaver wrote:
>> Thanks Adrian, noted. I'm hoping to get onto 8.4 before too long because
>> of the analytic functions but that thread suggests that the best course
>> of action would be to make sure that my code is robust against the new
>> server and then decide on an upgrade schedule.
>>
>> I'm building from scratch here so all options are as default except for
>> added Perl.
>>
>> --
>
> Alright then, nothing worse then trying to fix a problem that does not exist :)
"When a programmer has a hard time fixing a bug it's because he's
looking in the wrong place." :-)
> One other thing that came to mind in regards to the the 'changed record'
> problem is whether Row Versioning has been checked in the ODBC connection
> parameters?
No. However once I got to the point that a development machine was
looking at the new server I could reproduce the problem and (appear to
have) fixed it: the app was a scheduler running on a Windows system and
contained a lot of pathnames with backslashes hence
standard_conforming_strings = on.
I'll play with the new system for a few days and if all goes well try to
migrate on New Year's Day.
--
Mark Morgan Lloyd
markMLl .AT. telemetry.co .DOT. uk
[Opinions above are the author's, not those of his employers or colleagues]
From | Date | Subject | |
---|---|---|---|
Next Message | Allan Kamau | 2009-12-26 13:12:34 | Re: Session based transaction!! |
Previous Message | Bill Moran | 2009-12-26 12:02:00 | Re: Session based transaction!! |