Re: pg_restore depending on user functions

Поиск
Список
Период
Сортировка
От Дмитрий Иванов
Тема Re: pg_restore depending on user functions
Дата
Msg-id CAPL5KHouYG+Bi4DWYdzixUwJuL6HK9uruW5JKqU+1CJfB39G0Q@mail.gmail.com
обсуждение исходный текст
Ответ на Re: pg_restore depending on user functions  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: pg_restore depending on user functions  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
--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))
);

вт, 16 нояб. 2021 г. в 21:29, Tom Lane <tgl@sss.pgh.pa.us>:
Дмитрий Иванов <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

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: pg_restore depending on user functions
Следующее
От: Tom Lane
Дата:
Сообщение: Re: pg_restore depending on user functions