Re: Support for REINDEX CONCURRENTLY - Mailing list pgsql-hackers

From Michael Paquier
Subject Re: Support for REINDEX CONCURRENTLY
Date
Msg-id CAB7nPqTmOJk1xkGRxx4iOpAf3O1zD5wkZMUArnxNWxo9kKOt0w@mail.gmail.com
Whole thread Raw
In response to Re: Support for REINDEX CONCURRENTLY  (Fujii Masao <masao.fujii@gmail.com>)
Responses Re: Support for REINDEX CONCURRENTLY  (Fujii Masao <masao.fujii@gmail.com>)
Re: Support for REINDEX CONCURRENTLY  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-hackers
On Thu, Feb 28, 2013 at 11:26 PM, Fujii Masao <masao.fujii@gmail.com> wrote:
I found one problem in the latest patch. I got the segmentation fault
when I executed the following SQLs.

CREATE TABLE hoge (i int);
CREATE INDEX hogeidx ON hoge(abs(i));
INSERT INTO hoge VALUES (generate_series(1,10));
REINDEX TABLE CONCURRENTLY hoge;

The error messages are:

LOG:  server process (PID 33641) was terminated by signal 11: Segmentation fault
DETAIL:  Failed process was running: REINDEX TABLE CONCURRENTLY hoge;
Oops. Index expressions were not correctly extracted when building columnNames for index_create in index_concurrent_create.
Fixed in this new patch. Thanks for catching that.
--
Michael
Attachment

pgsql-hackers by date:

Previous
From: Steve Singer
Date:
Subject: Re: json generation enhancements
Next
From: Alex Hunsaker
Date:
Subject: Re: Memory leakage associated with plperl spi_prepare/spi_freeplan