Re: BUG #15114: logical decoding Segmentation fault - Mailing list pgsql-bugs

From Andres Freund
Subject Re: BUG #15114: logical decoding Segmentation fault
Date
Msg-id 20180326210643.xzoatxsyq2rptoc5@alap3.anarazel.de
Whole thread Raw
In response to Re: BUG #15114: logical decoding Segmentation fault  (Петър Славов <pet.slavov@gmail.com>)
Responses Re: BUG #15114: logical decoding Segmentation fault  (Петър Славов <pet.slavov@gmail.com>)
List pgsql-bugs
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


pgsql-bugs by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: BUG #15114: logical decoding Segmentation fault
Next
From: Петър Славов
Date:
Subject: Re: BUG #15114: logical decoding Segmentation fault