On Sun, Mar 10, 2013 at 3:48 AM, Fujii Masao <masao.fu...@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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
