--Line 4048:
CREATE TABLE bpd.class (
id bigint NOT NULL,
id_con bigint NOT NULL,
id_group bigint NOT NULL,
id_parent bigint NOT NULL,
id_root bigint NOT NULL,
level integer NOT NULL,
name character varying(100) NOT NULL,
"desc" character varying(2044) DEFAULT 'н/д'::text NOT NULL,
"on" boolean NOT NULL,
on_extensible boolean DEFAULT true NOT NULL,
on_abstraction boolean DEFAULT true NOT NULL,
id_unit_conversion_rule integer NOT NULL,
barcode_manufacturer bigint DEFAULT 0 NOT NULL,
barcode_local bigint DEFAULT 0 NOT NULL,
"timestamp" timestamp without time zone DEFAULT LOCALTIMESTAMP NOT NULL,
on_freeze boolean DEFAULT false NOT NULL,
id_group_root bigint DEFAULT 0 NOT NULL,
timestamp_parent timestamp without time zone DEFAULT LOCALTIMESTAMP(3) NOT NULL,
id_unit integer DEFAULT '-1'::integer NOT NULL,
timestamp_root timestamp without time zone NOT NULL,
timestamp_child_change timestamp without time zone DEFAULT LOCALTIMESTAMP(3) NOT NULL,
name_format character varying(255) DEFAULT 'none'::character varying NOT NULL,
quantity_show boolean DEFAULT true NOT NULL,
path_array bigint[] DEFAULT ARRAY[0] NOT NULL,
CONSTRAINT id CHECK ((id > 0)),
CONSTRAINT id_root CHECK ((id >= 0))
);
Дмитрий Иванов <firstdismay@gmail.com> writes:
> It turns out that everything was rolling like a snowball, after the wrong
> order of CAST creation
This is missing (at least) bpd.class.
regards, tom lane