I found the solution. Earlier for 9.0 database I have changed a line as Datestyle= ' ISO, mdy' to DateStyle= "ISO, dmy'. So it was working fine. For 9.1 I forgot to make this change in postgresql.conf. After making the change everything is working fine.
Regards, C P Kulkarni On Fri, Sep 23, 2011 at 3:43 PM, c k <shreeseva.learn...@gmail.com> wrote: > As I have connected to postgres from MS Access, it thrown the error. > Now I have updated ODBC driver, still same problems comes for 9.1 and not > for 9.0. There should be some thing that has changed in 9.1 release which > prevents from auto-conversion of format of date from client to server. > From package I have installed postgres 9.1 using EnterpriseDB one click > installer. > ODBC driver has version 9.0.3.10 > Should I file a bug for this? > > Regards, > C P Kulkarni > > > On Thu, Sep 22, 2011 at 7:42 PM, Adrian Klaver <adrian.kla...@gmail.com>wrote: > >> On Thursday, September 22, 2011 2:25:40 am c k wrote: >> > 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. >> >> What program threw the error, Access,ODBC or Postgres? >> >> > >> > 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. >> >> Define install, from source or package? >> >> > >> > 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. >> >> What version of the ODBC driver are using? >> >> FYI, there is a Postgres ODBC list: >> http://archives.postgresql.org/pgsql-odbc/ >> >> > >> > C P Kulkarni >> > >> >> >> -- >> Adrian Klaver >> adrian.kla...@gmail.com >> > >
