On 2018-03-26 22:59:12 +0200, Петър Славов wrote:
> Hi Andres,
>
> Alvaro, Petr: If I understand correctly what happens here is that some
> > *other* column than the replica identity has a predicate with a full
> > blown SQL function. We shouldn't evaluate arbitrary code like that
> > inside the otuput plugin!
> >
>
> Not sure what you mean here, but in my case the replica identity is a
> regular integer primary key, without any functions as predicates in the
> index or anything else.
Turns out it it's not the replica identity index that's the problem,
it's *another* index with a WHERE clause that evaluates an SQL
function. That's a bug that needs to be fixed. But you might be able to
work around it for now by simplifying your WHERE clauses for the indexes
to not use SQL functions.
Greetings,
Andres Freund