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.klaver@xxxxxxxxx -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
