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
Hi,
Is it possible to define logical replication where the source and destination
table names are not the same. I need to sync a table from some source, but
already have a table with the same name.
Thanks
Avi
IMPORTANT - This email and any attachments is intended for the above named
addressee
=?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
Спасибо за ваш отзыв.
вс, 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:
> вс, 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
Hello.
Thank you very much for your answer.
The configuration actually works for me. After restarting my computer, I
went to test again and it was already working. I assume that perhaps
because they are virtual machines it was not only enough to restart the
server, I think you also had to restart
On 14/11/2021 19:46, Yessica Brinkmann wrote:
Hello.
Thank you very much for your answer.
The configuration actually works for me.After restarting my computer, I
went to test again and it was already working. I assume that perhaps
because they are virtual machines it was not only enough to rest
On 11/14/21 11:55, Ray O'Donnell wrote:
On 14/11/2021 19:46, Yessica Brinkmann wrote:
Hello.
Thank you very much for your answer.
The configuration actually works for me.After restarting my computer,
I went to test again and it was already working. I assume that perhaps
because they are virtua
On 14/11/2021 20:16, Adrian Klaver wrote:
Actually that was already done:
https://www.postgresql.org/message-id/CAOR%2BmccGARtFsb7c%2BF%3DRUk832%3DdaaJ8%2ByQW8eBYa1Krypr4O6Q%40mail.gmail.com
The problems seems to have stemmed from this(per OP):
"Well, it turns out that at one point when I
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
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
=?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
12 matches
Mail list logo
