Re: Print baserestrictinfo for varchar fields

2019-06-03 Thread Michael Paquier
On Mon, Jun 03, 2019 at 01:37:22AM -0400, Tom Lane wrote: > It's hard to muster much enthusiasm for extending print_expr(), > considering how incomplete and little-used it is. I'd rather > spend effort on ripping it out in favor of using the far more > complete, and better-tested, code in ruleutil

Re: Print baserestrictinfo for varchar fields

2019-06-02 Thread Tom Lane
Donald Dong writes: > I noticed that debug_print_rel outputs "unknown expr" when the fields > in baserestrictinfo are typed as varchar. > ... > I wonder if this is a proper way of fixing it? It's hard to muster much enthusiasm for extending print_expr(), considering how incomplete and little-used

Print baserestrictinfo for varchar fields

2019-05-29 Thread Donald Dong
Hi, I noticed that debug_print_rel outputs "unknown expr" when the fields in baserestrictinfo are typed as varchar. create table tbl_a(id int, info varchar(32)); RELOPTINFO (tbl_a): rows=4 width=86 baserestrictinfo: unknown expr = pattern My approach is to handle the RelabelType case in