On Thu, 12 Jul 2018 15:58:08 +0900
Yugo Nagata <nagata@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 <nagata@sraoss.co.jp>