Re: pg_restore depending on user functions

Поиск
Список
Период
Сортировка
От Дмитрий Иванов
Тема Re: pg_restore depending on user functions
Дата
Msg-id CAPL5KHo46S6kRRiaTfNdm63eR3u72gcnS9zMa2DYOjqZyPrFsw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: pg_restore depending on user functions  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Yes, it is. 
I continue to extract data as promised, but I think I see some pattern.
"chicken or egg"
To work with the NPGSQL library, I created a cast. They are created after the views in which I use them.
Here is the order
279: CREATE TYPE bpd.cclass_prop
4646: CREATE VIEW bpd.vclass_prop
4784: CREATE FUNCTION bpd.int_cast_vclass_prop_to_cclass_prop(ivclass_prop bpd.vclass_prop) RETURNS bpd.cclass_prop
4803: CREATE VIEW bpd.int_class_ext AS
SELECT cp.id_class AS id,
array_agg((cp.*)::bpd.cclass_prop ORDER BY cp.sort) AS property_list
FROM bpd.vclass_prop cp
GROUP BY cp.id_class;
89428: CREATE CAST (bpd.vclass_prop AS bpd.cclass_prop) WITH FUNCTION bpd.int_cast_vclass_prop_to_cclass_prop(bpd.vclass_prop);

lost views:
"int_class_ext"
"int_doc_category_ext"
"int_doc_file_ext"
"int_doc_link_ext"
"int_object_ext"
"vclass_ext"
"vdocument_ext"
"vobject_general_ext"

пн, 15 нояб. 2021 г. в 20:49, Tom Lane <tgl@sss.pgh.pa.us>:
Дмитрий Иванов <firstdismay@gmail.com> writes:
> Is it ok to attach a 5MB data schema or is it not possible? Copy one by one
> to a letter?

Is it smaller if you omit the data (-s switch)?  Shouldn't be relevant
here.

                        regards, tom lane

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

Предыдущее
От: Дмитрий Иванов
Дата:
Сообщение: Re: pg_restore depending on user functions
Следующее
От: Saul Perdomo
Дата:
Сообщение: Re: Managing major PostgreSQL upgrades