Here is the table structure: The fields being updated are the ones that are NOT named field##.
Except for "3fc" which I left as is to show that it is named differently in the unlikely chance that this would be causing problems. CREATE TABLE main ( field01 character(10) COLLATE pg_catalog."default", field02 integer, field03 character varying(100) COLLATE pg_catalog."default", field04 character varying(50) COLLATE pg_catalog."default", field05 character varying(100) COLLATE pg_catalog."default", category character varying(100) COLLATE pg_catalog."default", field07 character varying(100) COLLATE pg_catalog."default", category_modified character varying(100) COLLATE pg_catalog."default", field09 text COLLATE pg_catalog."default", field10 character varying(100) COLLATE pg_catalog."default", field11 character(1) COLLATE pg_catalog."default", "3fc" character(3) COLLATE pg_catalog."default", field12 text COLLATE pg_catalog."default", field13 text COLLATE pg_catalog."default", field14 text COLLATE pg_catalog."default", field15 text COLLATE pg_catalog."default", field16 COLLATE pg_catalog."default", sub_category character(10) COLLATE pg_catalog."default", field17 character varying(100) COLLATE pg_catalog."default", field18 character varying(100) COLLATE pg_catalog."default", field19 character varying(100) COLLATE pg_catalog."default", field20 character varying(50) COLLATE pg_catalog."default", code1 character(5) COLLATE pg_catalog."default", code2 character(10) COLLATE pg_catalog."default", field21 character varying(100) COLLATE pg_catalog."default", field22 character varying(50) COLLATE pg_catalog."default", field23 character varying(50) COLLATE pg_catalog."default", field24 character varying(50) COLLATE pg_catalog."default", field25 character varying(50) COLLATE pg_catalog."default", field26 character varying(50) COLLATE pg_catalog."default", field27 character varying(50) COLLATE pg_catalog."default", field28 character varying(50) COLLATE pg_catalog."default", field29 character varying(50) COLLATE pg_catalog."default", field31 character varying(50) COLLATE pg_catalog."default", field32 character varying(10) COLLATE pg_catalog."default", field33 varying(10) COLLATE pg_catalog."default", field34 varying(10) COLLATE pg_catalog."default", field35 varying(10) COLLATE pg_catalog."default", field36 character varying(50) COLLATE pg_catalog."default", field37 character(1) COLLATE pg_catalog."default", field38 character varying(50) COLLATE pg_catalog."default", field39 boolean, field40 boolean, field41 boolean);
