Re: row filtering for logical replication

2019-09-03 Thread Alexey Zagarin
> OK, I'll consider Alexey Kondratov's set of patches as the current > state-of-the-art then. (They still apply.) Alexey's patch is the rebased version of previous Euler's patch set, with slot type mistake fixed, and adapted to current changes in the master branch. It also has testing improvemen

Re: row filtering for logical replication

2019-09-02 Thread Alexey Zagarin
> There are complaints in the log (both pub and sub) like: > ERROR: trying to store a heap tuple into wrong type of slot > > I have no idea what causes that. Yeah, I've seen that too. It was fixed by Alexey Kondratov, in line 955 of 0005-Row-filtering-for-logical-replication.patch it should be &T

Re: row filtering for logical replication

2019-08-31 Thread Alexey Zagarin
same condition, e.g. COPY (SELECT * FROM ... WHERE ...) TO ... The current workaround is to always use WITH copy_data = false when subscribing or refreshing, and then manually copy data with the above statement. Alexey Zagarin On 1 Sep 2019 12:11 +0700, Euler Taveira , wrote: > Em ter, 27 d