Re: Updating from 8.2 to 8.4

Adrian Klaver wrote:
> On Thursday 24 December 2009 11:20:35 am Mark Morgan Lloyd wrote:
>> I was hoping to finally get the servers updated from 8.2 to 8.4 over the
>> festive season, but by now I think I've left things too tight.
>>
>> Is it necessary to update the (Windows) ODBC driver as well? I've got a
>> couple of app servers still on NT4 with ODBC 8.02.0100 which I'm trying
>> to be careful with lest I put something on them which requires a later
>> OS and can't back out.
>>
>> The apps are written in a rather old version of Delphi with BDE which is
>> fine with 8.2. Trying to run against 8.4 I get "Couldn't perform the
>> edit because another user changed the record."- looking back through
>> this and other MLs I see suggestion that this could be caused by an
>> excessive number of decimal places in the data (current case only
>> contains integers, timestamps and text) or possibly by a transaction
>> isolation issue.
>
> My experience with this is it related to timestamps with fractional second
> precision. The other thing to note is that in 8.4 the default for datetimes is
> now 64-bit integer datetimes, not the previous float datetimes.

Many thanks for that Adrian. I notice this in the ODBC release notes
which could be relevant:

-----8<-----
psqlODBC 08.04.0100 Release
..
8.) Remove a spurious "." with no trailing digits in timestamp
representation (bug report [#1010540] from Brian Feldman).
----->8-----

although I don't know why it didn't bite on 8.2 unless it's specifically
when 64-bit timestamps are processed.

I think that I'll try an ODBC update on a non-critical system, if that
doesn't work I'll dig into my code. The table giving problems is part of
a scheduling program where I can probably truncate timestamps, elsewhere
it might not be so convenient. I'll report back if I find anything
interesting.

The sooner I can get this code off Delphi+BDE+ODBC+Windows to
Lazarus+Linux the better.

Happy Christmas everybody, whatever country you're in and whatever your
tradition of celebration. We run 24x365 here but the caterers are hard
at work :-)

--
Mark Morgan Lloyd
markMLl .AT. telemetry.co .DOT. uk

[Opinions above are the author's, not those of his employers or colleagues]