From: | Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com> |
---|---|
To: | c k <shreeseva(dot)learning(at)gmail(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org, "pgsql-admin" <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: [GENERAL] Date time value error in Ms Access using pass through queries |
Date: | 2011-09-22 14:12:03 |
Message-ID: | 201109220712.03827.adrian.klaver@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-general |
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(dot)klaver(at)gmail(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Patrick Garner | 2011-09-22 23:51:55 | Re: Question about GSSAPI |
Previous Message | Chris Ernst | 2011-09-22 11:55:09 | Re: Question about GSSAPI |
From | Date | Subject | |
---|---|---|---|
Next Message | Rafal Pietrak | 2011-09-22 14:29:02 | Re: why VOLATILE attribute is required? |
Previous Message | Tom Lane | 2011-09-22 14:05:38 | Re: why VOLATILE attribute is required? |