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: CR
Yes, it is.
I'll leave behind the lost features, views, table definitions, and
dependent objects. It will take some time.
thanks, for the help.
пн, 15 нояб. 2021 г. в 20:49, Tom Lane :
> =?UTF-8?B?0JTQvNC40YLRgNC40Lkg0JjQstCw0L3QvtCy?=
> writes:
> > Is it ok to attach a 5MB data schema or is it
Yes, it is.
I did so (--schema-only). Removing unnecessary definitions.
That is, you do not need to attach files?
пн, 15 нояб. 2021 г. в 20:49, Tom Lane :
> =?UTF-8?B?0JTQvNC40YLRgNC40Lkg0JjQstCw0L3QvtCy?=
> writes:
> > Is it ok to attach a 5MB data schema or is it not possible? Copy one by
> on
=?UTF-8?B?0JTQvNC40YLRgNC40Lkg0JjQstCw0L3QvtCy?= 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
Thanks for the feedback!
Is it ok to attach a 5MB data schema or is it not possible? Copy one by one
to a letter?
It would be nice if in the end I could rebuild the base without hindrance.
Thank you in advance.
Restore Windows 10 PostgreSQL 12.9, compiled by Visual C++ build 1914,
64-bit -> Debian
=?UTF-8?B?0JTQvNC40YLRgNC40Lkg0JjQstCw0L3QvtCy?= writes:
> вс, 14 нояб. 2021 г. в 23:46, Tom Lane :
>> This is not "details", this is an evidence-free assertion. Please show
>> a concrete example of problematic functions.
> Ok, I'll do it.
> [ example ]
This is pretty far from being a self-cont
Ok, I'll do it.
> Сreating function A before function B results in a compilation error.
On my part, this is an incorrect assumption. There are no compilation
errors here. she just didn't recover from the first pass.
вс, 14 нояб. 2021 г. в 23:46, Tom Lane :
> =?UTF-8?B?0JTQvNC40YLRgNC40Lkg0JjQstCw
Ok, I'll do it.
вс, 14 нояб. 2021 г. в 23:46, Tom Lane :
> =?UTF-8?B?0JTQvNC40YLRgNC40Lkg0JjQstCw0L3QvtCy?=
> writes:
> > вс, 14 нояб. 2021 г. в 22:31, Tom Lane :
> >> Usually this is caused by being careless about search_path assumptions
> >> in your functions ... but with no details, it's impo
=?UTF-8?B?0JTQvNC40YLRgNC40Lkg0JjQstCw0L3QvtCy?= writes:
> вс, 14 нояб. 2021 г. в 22:31, Tom Lane :
>> Usually this is caused by being careless about search_path assumptions
>> in your functions ... but with no details, it's impossible to say
>> anything with certainty.
> No, in this case it is n
Спасибо за ваш отзыв.
вс, 14 нояб. 2021 г. в 22:31, Tom Lane :
> =?UTF-8?B?0JTQvNC40YLRgNC40Lkg0JjQstCw0L3QvtCy?=
> writes:
> > 1. I can determine the dependencies of the custom functions when creating
> > the pg_dump? I did not find anything suitable for SUPPORT, probably this
> is
> > not the
=?UTF-8?B?0JTQvNC40YLRgNC40Lkg0JjQstCw0L3QvtCy?= writes:
> 1. I can determine the dependencies of the custom functions when creating
> the pg_dump? I did not find anything suitable for SUPPORT, probably this is
> not the case?
> To recreate all of the functionality, I had to run schema recovery tw
Good day!
Deploying a cluster: from PostgreSQL 12 Windows 10 (EDB) to PostgreSQL 14
Debian 11.
In general, I succeeded, but there are a number of questions:
1. I can determine the dependencies of the custom functions when creating
the pg_dump? I did not find anything suitable for SUPPORT, probably
12 matches
Mail list logo
