From: | jack <jack4pg(at)a7q(dot)com> |
---|---|
To: | "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | re: constant crashing |
Date: | 2024-04-14 19:44:40 |
Message-ID: | IDeg1sikmShsu7p3r1np9CJ3x1FKf5FPQHoyjiUnIeq40q31rG8DUiTbuMTZNqn4qQDyfo8m3BmEbSCcQ2-GDA8ZCJwmAPLk-7tYhhaa_e4=@a7q.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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);
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2024-04-14 19:57:15 | Re: constant crashing |
Previous Message | Tom Lane | 2024-04-14 19:30:45 | Re: constant crashing |