Query related to Logical Replication using test_decoding and unchanged-toast-datum

2025-01-06 Thread Kiran K V
Hi, I am currently using PostgreSQL version 16 and the test_decoding plugin to perform logical replication (using replication slots). I have a simple table with integer column and JSON column. When a non-JSON column is updated, the value "unchanged-toast-datum" for the JSON column is obtained. Thi

Re: Issue with loading unicode characters with copy command

2024-01-14 Thread Kiran K V
Its UTF-8. Also verified the load file and its utf-8. Regards, Kiran On Fri, Jan 12, 2024 at 10:48 PM Adrian Klaver wrote: > On 1/12/24 07:23, Kiran K V wrote: > > Hi, > > > > > > I have a UTF8 database and simple table with two columns (integer and > > varch

Issue with loading unicode characters with copy command

2024-01-12 Thread Kiran K V
Hi, I have a UTF8 database and simple table with two columns (integer and varchar). Created a csv file with some multibyte characters and trying to perform load operation using the copy command. Database info: Postgresql database details: Name| Owner | Encoding | Collate

ERROR: invalid byte sequence for encoding UTF8: 0x00

2024-01-09 Thread Kiran K V
Hi, I have a table with bytea column and trying to load the data using copy command. But Copy command is failing with "ERROR: invalid byte sequence for encoding UTF8: 0x00. Why postgresql is failing to load when data contains 0x00. How to resolve this error ? any workaround to load the data with