Thread: [HACKERS] Restrictions of logical replication

Maybe I am missing something, but I could not find any description
that logical replication does not support large objects and TRUNCATE
in the doc.  Do we want to add them to the doc as the restrictions of
the logical replication?

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp

Hi Tatsuo,

On Fri, Jun 16, 2017 at 04:00:56PM +0900, Tatsuo Ishii wrote:
> Maybe I am missing something, but I could not find any description
> that logical replication does not support large objects and TRUNCATE
> in the doc.  Do we want to add them to the doc as the restrictions of
> the logical replication?

I knew about TRUNCATE and it most definitely should be documented if
it's not yet. And what about large objects?

--
Best regards,
Aleksander Alekseev

On 6/16/17 03:00, Tatsuo Ishii wrote:
> Maybe I am missing something, but I could not find any description
> that logical replication does not support large objects and TRUNCATE
> in the doc.  Do we want to add them to the doc as the restrictions of
> the logical replication?

Some of that information was sprinkled around, but I have now added a
new section that collects them all in one place.  (section 31.4)

-- 
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

> On 6/16/17 03:00, Tatsuo Ishii wrote:
>> Maybe I am missing something, but I could not find any description
>> that logical replication does not support large objects and TRUNCATE
>> in the doc.  Do we want to add them to the doc as the restrictions of
>> the logical replication?
> 
> Some of that information was sprinkled around, but I have now added a
> new section that collects them all in one place.  (section 31.4)

Great. Thanks!
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp

> Docs stated "Publications can choose to limit the changes they produce to
> any combination of INSERT, UPDATE, and DELETE". It is clear that only those
> DMLs are supported.

What about COPY?

> However, we should mention that large objects are not
> supported.

Right.

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp

>> Some of that information was sprinkled around, but I have now added a
>> new section that collects them all in one place.  (section 31.4)
> 
> 
> Shouldn't we mention that COPY is supported?

I think any commands that are not mentioned in the section are
considered to be supported.

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp

On 6/16/17 10:59, Tatsuo Ishii wrote:
>> Docs stated "Publications can choose to limit the changes they produce to
>> any combination of INSERT, UPDATE, and DELETE". It is clear that only those
>> DMLs are supported.
> 
> What about COPY?

Sure, added note about that as well.

-- 
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services