It shows error as 'Date/time value out of range' and gives the actual part of the sql statement which contains date as the details.
I have installed both databases at different locations on same drive on Fedora 15 and accessing it from Windows Xp virtual machine.
And both databases from 9.0. and 9.1 have same structure and and it is found that this problem comes for all date columns for 9.1. There is no such problem for 9.0 at all.
When same query is executed from PgAdmin it executed successfully for 9.1. So the error may be in ODBC driver and some things related to date data type may be changed in 9.1.
C P Kulkarni
On Wed, Sep 21, 2011 at 7:05 PM, Adrian Klaver
<adrian.klaver@gmail.com> wrote:
On Wednesday, September 21, 2011 3:08:11 am c k wrote:
> Hello,
>
> I got a error yesterday while I have updated my development database to 9.1
> from 9.0.4. I backed up my database from 9.0 and restored in 9.1. It well
> successfully. When running a query which calls a function, having date
> value as IN parameter, it gives me the error as date/time value out of
> range. But when same query is executed using a database from 9.0.4 it runs
> successfully without any error. Both databases have a variable
> 'DateStyle=DMY' set. All connection parameters are same for both. What is
> the problem? Does some thing is changed in 9.1 or I have to wait till new
> ODBC driver is released? I am using four digit year format and regional
> settings are set to use dd/mm/yyyy style on windows and MS access uses
> them. Please give your reply.
How did you install the 9.1 versus 9.0 databases?
Related to the above question do the 9.0 and 9.1 have the same storage type
(float or integer) for datetime values?
>
> Thanks and regards,
>
> C P Kulkarni
Adrian Klaver
adrian.klaver@gmail.com