Re: Failure to create GiST on ltree column

[Justin Pryzby]

On Mon, May 25, 2020 at 04:41:49PM +0300, Victor Yegorov wrote:
> New index to be created:
> CREATE INDEX i_mp_comments_mpath_gist ON comments.mp_comments USING gist 
> (mpath);

I wonder if/how that fails if you create the index before adding data:

CREATE TABLE test_path(path ltree);
CREATE INDEX ON test_path USING GIST(path);
INSERT INTO test_path SELECT * FROM comments.mp_comments;

Does that fail on a particular row ?

How many paths do you have and how long?  How big is the table?

-- 
Justin