Hello again Brad, and hello Tom. Thanks for writing, and Tom I'll add some
extra thanks for the many google searches over the years which have been
answered by your posts. :)
It seems there's been some confusion on the data flow so I'll try to explain.
The original "source" I referred to was our
"Brad Nicholson" writes:
> Thomas Tignor wrote on 03/25/2019 08:25:49 PM:
>> Thanks for writing. As I mentioned to Vijay, the "source" is a JVM
>> using the postgres v42.0.0 JDBC driver. I do not believe we have any
>> explicit encoding set, and so I expect the client encoding is
>> SQL_ASCII. Th
Thomas Tignor wrote on 03/25/2019 08:25:49 PM:
>
> Hi Brad,
> Thanks for writing. As I mentioned to Vijay, the "source" is a JVM
> using the postgres v42.0.0 JDBC driver. I do not believe we have any
> explicit encoding set, and so I expect the client encoding is
> SQL_ASCII. The DB is most defi
Hi Brad,Thanks for writing. As I mentioned to Vijay, the "source" is a JVM
using the postgres v42.0.0 JDBC driver. I do not believe we have any explicit
encoding set, and so I expect the client encoding is SQL_ASCII. The DB is most
definitely UTF8. Our log shows no issue with the input data we'v
Hi Vijay,Thanks for writing. To your questions:
i think the experts will chime in soon,
but why do you think this as db corruption and not just a bad input?
https://github.com/postgres/postgres/blob/master/src/pl/plperl/expected/plperl_lc_1.out
tptignor: Our JVM logs data before the insert and
Vijaykumar Jain wrote on 03/25/2019 03:07:19 PM:
> but why do you think this as db corruption and not just a bad input?
> https://urldefense.proofpoint.com/v2/url?
>
u=https-3A__github.com_postgres_postgres_blob_master_src_pl_plperl_expected_plperl-5Flc-5F1.out&d=DwIFaQ&c=jf_iaSHvJObTbx-
> siA
i think the experts will chime in soon,
but why do you think this as db corruption and not just a bad input?
https://github.com/postgres/postgres/blob/master/src/pl/plperl/expected/plperl_lc_1.out
or it may also be encoding issue.
https://pganalyze.com/docs/log-insights/app-errors/U137
can you d
