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

Hi, psqlodbc commiters.

> --- 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.

Could someone confirm this?
I think this is a tiny bug..

Best Regards,

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