On Thu, 12 Jul 2018 15:58:08 +0900 Yugo Nagata <nag...@sraoss.co.jp> wrote: > Yes, more simplly, the following query also works; > > CREATE INDEX ON test((i)) INCLUDE (i); > > However, a problem is that when we use pg_dump for the database, this > generate the following query > > CREATE INDEX test_i_i1_idx ON public.test USING btree (i) INCLUDE (i); > > Of cause, this causes the "must not intersect" error, and we cannot restore > this dump. > > To fix this, we agree with Tom about getting rid of "must not intersect" > restriction. > A patch is attached for this
Should we add this to PG11 open items? -- Yugo Nagata <nag...@sraoss.co.jp>