Skip site navigation (1) Skip section navigation (2)

Re: New release of psqODBC?

From: Avery Payne <apayne(at)pcfruit(dot)com>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Re: New release of psqODBC?
Date: 2006-10-12 18:10:10
Message-ID: 452E8502.2080908@pcfruit.com (view raw or flat)
Thread:
Lists: pgsql-odbc
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
  <meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
<pre style="margin: 0em;"><font face="Arial, Helvetica, sans-serif">Dave Page wrote:
</font></pre>
<blockquote
 style="border-left: 0.2em solid rgb(85, 85, 238); margin: 0em; padding-left: 0.85em;"><font
 face="Arial, Helvetica, sans-serif"><tt> </tt><tt></tt></font>
  <blockquote
 style="border-left: 0.2em solid rgb(85, 85, 238); margin: 0em; padding-left: 0.85em;">
    <pre style="margin: 0em;"><font face="Arial, Helvetica, sans-serif">-----Original Message-----
</font></pre>
    <font face="Arial, Helvetica, sans-serif"><tt>From: Hiroshi Saito [<a
 rel="nofollow" href="mailto:z-saito">mailto:z-saito</a> ( at ) guitar
( dot ) ocn ( dot ) ne ( dot ) jp] </tt><tt>Sent: 10 October 2006
17:19
    </tt></font>
    <pre style="margin: 0em;"><font face="Arial, Helvetica, sans-serif">To: Dave Page; Hiroshi Inoue
Cc: pgsql-odbc ( at ) postgresql ( dot ) org
Subject: Re: [ODBC] New release of psqODBC?

</font></pre>
    <blockquote
 style="border-left: 0.2em solid rgb(85, 85, 238); margin: 0em; padding-left: 0.85em;"><font
 face="Arial, Helvetica, sans-serif"><tt>From: Dave Page </tt><tt>I've
never saw a reply to this question - can you comment please?
      </tt></font></blockquote>
    <pre style="margin: 0em;"><font face="Arial, Helvetica, sans-serif">Hi Dave.

</font></pre>
    <font face="Arial, Helvetica, sans-serif"><tt>As for me, tests of
08.02.0102 of the present version is not </tt><tt>completed yet.
    </tt></font>
    <pre style="margin: 0em;"><font face="Arial, Helvetica, sans-serif">1.) *nix build for iODBC and unixODBC
2.) *nix build 64bit mode.
3.) MS build for VS2005.
4.) MS build 64bit mode.
5.) MSDTC...

</font></pre>
    <font face="Arial, Helvetica, sans-serif"><tt>Someone can help
them. However, it was not necessarily </tt><tt>decided that they </tt><tt>would
be the specifications still opened wide.
    </tt></font><font face="Arial, Helvetica, sans-serif"><tt>Inoue-san
has included them and correcting the some bugs. </tt><tt>It seems that
it becomes the Version 08.02.0103 edition. </tt></font></blockquote>
  <pre style="margin: 0em;"><font face="Arial, Helvetica, sans-serif">Well, we should really gather some of the bug fixes from 08.02.0100 into
an 08.02.0200 release ready for inclusion with pgInstaller. We can
always add further improvements in later versions.

</font></pre>
  <blockquote
 style="border-left: 0.2em solid rgb(85, 85, 238); margin: 0em; padding-left: 0.85em;">
    <pre style="margin: 0em;"><font face="Arial, Helvetica, sans-serif">However, Inoue-san is very busy now....
</font></pre>
  </blockquote>
</blockquote>
<pre style="margin: 0em;"><font face="Arial, Helvetica, sans-serif">&gt;Sorry for the late answer.
&gt;Unfortunately I can't solve the problems reported by Avery or Andrus yet.
&gt;Anyway I would commit the changes in a day or 2.

&gt;regards,
&gt;Hiroshi Inoue
</font><font><font face="Arial, Helvetica, sans-serif">
Don't wait for me,</font></font> <font
 face="Arial, Helvetica, sans-serif">the empty date issue is about as resolved as it will get.  I've dug a little deeper into
ODBC and it seems that ODBC has no concept of "empty dates", so there really isn't a way to get the
driver to represent NULLs as empties when going PostgreSQL-&gt;ODBC-&gt;FoxPro.  However, converting
empties to NULL is a very practical approach and will be useful to several people. At least it works for
FoxPro-&gt;ODBC-&gt;PostgreSQL, and that solves all kinds of problems right there.  I would be so bold as
to even suggest that it become a default behavior in the driver, silently converting "empty dates" from
Microsoft data sources into NULL; this appears to be the default behavior for MS Access as well,
so I doubt it will cause issues.
</font></pre>
</body>
</html>


Attachment: unknown_filename
Description: text/html (3.9 KB)

pgsql-odbc by date

Next:From: Dmitriy IvanovDate: 2006-10-13 06:41:49
Subject: Re: Representing Empty DATE values as NULL
Previous:From: Avery PayneDate: 2006-10-12 17:22:29
Subject: Re: Representing Empty DATE values as NULL

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group