Re: The multi-column index create fail

You need to install the btree_gin extension, with CREATE EXTENSION, in each
database that you want such indexes.

See: https://www.postgresql.org/docs/current/static/btree-gin.html
and
https://www.postgresql.org/docs/current/static/sql-createextension.html

On Mon, Nov 6, 2017 at 3:47 AM, <2512498635(at)qq(dot)com> wrote:

> The following documentation comment has been logged on the website:
>
> Page: https://www.postgresql.org/docs/10/static/gin-tips.html
> Description:
>
> I fail to create multi-column index use following statements:
> create table t_gin3 (id int, c1 int, c2 int, c3 int, c4 int, c5 int, c6
> int,
> c7 int, c8 int, c9 int);
> create index idx_t_gin3_1 on t_gin3 using GIN
> (c1,c2,c3,c4,c5,c6,c7,c8,c9);
>
> but the document says gin supports multi-columns
>
> --
> Sent via pgsql-docs mailing list (pgsql-docs(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-docs
>