Re: [BUGS] There is a case in which psqlodbc-09.03.0400 returns unterminated strings on Windows. - Mailing list pgsql-odbc

> Yep. This was already fixed in git master in January, in commit
> 532c0dad20087201feee3851652c114eb820311f.

Thank you!

I confirmed psql-odbc master is already fixed this bug.
While you are at it, could you fix a precision argument passed to stime2timestamp?


--- C:/work/psqlodbc-a2def3d/convert.c.orig    Wed Sep 23 16:14:10 2015
+++ C:/work/psqlodbc-a2def3d/convert.c    Thu Sep 24 09:01:50 2015
@@ -1247,8 +1247,7 @@
             case PG_TYPE_TIMESTAMP:
                 /* sprintf(rgbValueBindRow, "%.4d-%.2d-%.2d %.2d:%.2d:%.2d",
                     std_time.y, std_time.m, std_time.d, std_time.hh, std_time.mm, std_time.ss); */
-                len = stime2timestamp(&std_time, rgbValueBindRow, cbValueMax, FALSE,
-                                      (int) (cbValueMax - len - 2) );
+                len = stime2timestamp(&std_time, rgbValueBindRow, cbValueMax, FALSE, 6 );
                 if (len + 1 > cbValueMax)
                     result = COPY_RESULT_TRUNCATED;
                 break;

In PostgreSQL, I think max number of digits of precision is always 6.

I hope to be able to use next release as soon as possible.

Regards,

Naoya
---
Naoya Anzai
Engineering Department
NEC Solution Inovetors, Ltd.
E-Mail: nao-anzai@xc.jp.nec.com
---