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

On Sun, Mar 10, 2013 at 3:48 AM, Fujii Masao <masao.fujii@gmail.com> wrote:
> Thanks for updating the patch!

-                              "SELECT reltoastidxid "
-                              "FROM info_rels i JOIN pg_catalog.pg_class c "
-                              "        ON i.reloid = c.oid"));
+                              "SELECT indexrelid "
+                              "FROM info_rels i "
+                              "  JOIN pg_catalog.pg_class c "
+                              "    ON i.reloid = c.oid "
+                              "  JOIN pg_catalog.pg_index p "
+                              "    ON i.reloid = p.indrelid "
+                              "WHERE p.indexrelid >= %u ", FirstNormalObjectId));

This new SQL doesn't seem to be right. Old one doesn't pick up any indexes
other than toast index, but new one seems to do.

Regards,

-- 
Fujii Masao