Re: [Sender Address Forgery]Re: error message when subscriptiontarget is a partitioned table - Mailing list pgsql-hackers

From Amit Langote
Subject Re: [Sender Address Forgery]Re: error message when subscriptiontarget is a partitioned table
Date
Msg-id 61a37c5e-5307-7c12-aa90-a8bf978d8d75@lab.ntt.co.jp
Whole thread Raw
In response to Re: [Sender Address Forgery]Re: error message when subscriptiontarget is a partitioned table  (Arkhena <Arkhena@gmail.com>)
Responses Re: [Sender Address Forgery]Re: error message when subscriptiontarget is a partitioned table
List pgsql-hackers
Hi,

On 2019/01/10 17:46, Arkhena wrote:
>> Your rewritten version is perhaps fine, although I remain a bit concerned
>> that some users might be puzzled when they see this error, that is, if
>> they interpret the message as "it's impossible to use a partitioned table
>> as logical replication target".
>>
>>
>>From [documentation](
> https://www.postgresql.org/docs/current/logical-replication-restrictions.html
> ) :
>> Attempts to replicate tables other than base tables will result in an
> error.
> 
> That's basicaly what I had understood about logicial replication...

Ah, if the documentation contains such description then maybe it's fine.

The reason I started this thread is due to this Stack Overflow question:

https://stackoverflow.com/questions/53554727/logical-replication-and-declarative-partitioning-in-postgresql-11

So, it appears that there may be an element of surprise involved in
encountering such an error (despite the documentation).

Thanks,
Amit



pgsql-hackers by date:

Previous
From: Arkhena
Date:
Subject: Re: [Sender Address Forgery]Re: error message when subscriptiontarget is a partitioned table
Next
From: Fabien COELHO
Date:
Subject: Re: [HACKERS] pgbench - allow to store select results intovariables