Re: Logical Replication - detail message with names of missing columns
| От | Bharath Rupireddy | 
|---|---|
| Тема | Re: Logical Replication - detail message with names of missing columns | 
| Дата | |
| Msg-id | CALj2ACVy+W8SeH2OddN2H8a7PLeSv1ue4ugj9dKZOVw6kCX+HA@mail.gmail.com обсуждение исходный текст  | 
		
| Ответ на | Re: Logical Replication - detail message with names of missing columns (Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>) | 
| Ответы | 
                	
            		Re: Logical Replication - detail message with names of missing columns
            		
            		 | 
		
| Список | pgsql-hackers | 
Thanks for the comments, v2 patch is attached. > > On Tue, Sep 8, 2020 at 6:50 AM Kyotaro Horiguchi > <horikyota.ntt@gmail.com> wrote: > > > > +1 for objective. However, that can be done simpler way that doesn't > > need additional loops by using bitmapset to hold missing remote > > attribute numbers. This also make the variable "found" useless. > > > > Thanks. I will look into it and post a v2 patch soon. > Changed. > > > > FWIW, I would prefer that the message be like > > > > logical replication target relation "public.test_1" is missing > > replicated columns: "a1", "c1" > > > > This looks fine, I will change that. > Changed. Now the error looks like as shown below: ERROR: logical replication target relation "public.test_tbl1" is missing replicated columns:"d1" ERROR: logical replication target relation "public.test_tbl1" is missing replicated columns:"c1","d1" ERROR: logical replication target relation "public.test_tbl1" is missing replicated columns:"a1","c1","d1" ERROR: logical replication target relation "public.test_tbl1" is missing replicated columns:"a1","b1","c1","d1" ERROR: logical replication target relation "public.test_tbl1" is missing replicated columns:"a1","b1","c1","d1","e1" With Regards, Bharath Rupireddy. EnterpriseDB: http://www.enterprisedb.com
Вложения
В списке pgsql-hackers по дате отправления: