| From: | Dave Cramer <davecramer(at)postgres(dot)rocks> |
|---|---|
| To: | "Chatterjee, Ankush" <anchatterjee(at)informatica(dot)com> |
| Cc: | "pgsql-jdbc(at)postgresql(dot)org" <pgsql-jdbc(at)postgresql(dot)org> |
| Subject: | Re: Bug regarding PostgreSQL JDBC driver truncating microseconds to milliseconds |
| Date: | 2021-03-29 14:25:00 |
| Message-ID: | CADK3HHKCn4AbzZVGYCXhq6BB0N94ZJOt+YxBTADCUt1Dwz+HHA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-jdbc |
On Wed, 17 Mar 2021 at 16:17, Chatterjee, Ankush <
anchatterjee(at)informatica(dot)com> wrote:
> Hi,
>
> We are observing that the postgresql JDBC driver is truncating
> microseconds data to milliseconds when writing to a table.
>
>
>
>
>
>
>
> Regards,
>
> *Ankush Chatterjee* | Associate Software Engineer
>
> No 66/1, Bagmane Commerz 02, Bagmane Tech Park, CV Raman Nagar, Bangalore
> - 560093
>
> Mobile: +91 9064272133
>
> Email: anchatterjee(at)informatica(dot)com
>
>
> <https://nam02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.linkedin.com%2Fcompany%2Finformatica%3Ftrk%3Dhb_tab_compy_id_3858&data=02%7C01%7Canchatterjee%40informatica.com%7Cd3a90c5778f44304d7bc08d72233d803%7C2638f43ef77d4fc7ab927b753b7876fd%7C0%7C0%7C637015478374589861&sdata=w36SKinGYQ3oXPrUzTobuRHq216uFQMm7Nf4qhXvWvE%3D&reserved=0>
> <https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.facebook.com%2FInformaticaLLC&data=02%7C01%7Canchatterjee%40informatica.com%7Cd3a90c5778f44304d7bc08d72233d803%7C2638f43ef77d4fc7ab927b753b7876fd%7C0%7C0%7C637015478374599855&sdata=rxAtEPPLKkcr%2FzdbfVRs6zJaE8v9HBYqzLE4PcvGXTI%3D&reserved=0>
> <https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Ftwitter.com%2FInformatica&data=02%7C01%7Canchatterjee%40informatica.com%7Cd3a90c5778f44304d7bc08d72233d803%7C2638f43ef77d4fc7ab927b753b7876fd%7C0%7C0%7C637015478374599855&sdata=MeTx%2Brgsa70rB0q9svsYf62HXyPkMTq1LBg%2FehIUvZI%3D&reserved=0>
> <https://nam02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fblogs.informatica.com%2F&data=02%7C01%7Canchatterjee%40informatica.com%7Cd3a90c5778f44304d7bc08d72233d803%7C2638f43ef77d4fc7ab927b753b7876fd%7C0%7C0%7C637015478374609853&sdata=IB7ZOrzPVaShdndyEJ3Cx%2B1DOiF84sbN2mzIfuISPPA%3D&reserved=0>
> <https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fplus.google.com%2Fu%2F0%2F103247695984201166817%2Fposts&data=02%7C01%7Canchatterjee%40informatica.com%7Cd3a90c5778f44304d7bc08d72233d803%7C2638f43ef77d4fc7ab927b753b7876fd%7C0%7C0%7C637015478374609853&sdata=lkN17VP0YZxqaf4E5mhu60MLETMMH7YdEUKFNF6mViw%3D&reserved=0>
> <https://nam02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fblogs.informatica.com%2Ffeed%2F&data=02%7C01%7Canchatterjee%40informatica.com%7Cd3a90c5778f44304d7bc08d72233d803%7C2638f43ef77d4fc7ab927b753b7876fd%7C0%7C0%7C637015478374609853&sdata=2%2BmzWABUFoAHinO%2BdFtVYMhsc7tQcyjqURcCbnQAJ14%3D&reserved=0>
> <https://nam02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.youtube.com%2Fuser%2FInformaticaCorp&data=02%7C01%7Canchatterjee%40informatica.com%7Cd3a90c5778f44304d7bc08d72233d803%7C2638f43ef77d4fc7ab927b753b7876fd%7C0%7C0%7C637015478374619845&sdata=NS6LdjJ9qWeY%2FmSWclY4WqyYeLPceTlVHcXBbMcdjeg%3D&reserved=0>
>
>
>
>
> <https://nam02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.informatica.com%2F&data=02%7C01%7Canchatterjee%40informatica.com%7Cd3a90c5778f44304d7bc08d72233d803%7C2638f43ef77d4fc7ab927b753b7876fd%7C0%7C0%7C637015478374619845&sdata=eq16YVSe5EDzfzZhdzYpuzJ3yNzrtute0e5BqXf5gBE%3D&reserved=0>
>
>
>
need to see the queries that caused this
Version of the driver ?
Dave Cramer
www.postgres.rocks
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Laurenz Albe | 2021-04-01 09:34:59 | [pgjdbc/pgjdbc] 187333: Correctly indent code sample in the "options" docu... |
| Previous Message | Dave Cramer | 2021-03-29 14:19:13 | Re: Exception while updating result set |