Re: [HACKERS] REINDEX CONCURRENTLY 2.0

On 07/12/2018 17:40, Sergei Kornilov wrote:
> I perform some tests and think behavior with partition tables is slightly inconsistent.
> 
> postgres=# reindex table measurement;
> WARNING:  REINDEX of partitioned tables is not yet implemented, skipping "measurement"
> NOTICE:  table "measurement" has no indexes
> REINDEX
> postgres=# reindex table CONCURRENTLY measurement;
> ERROR:  cannot reindex concurrently this type of relation
> 
> Maybe we need report warning and skip partitioned tables similar to plain reindex?

OK, that should be easy to fix.

-- 
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services