]> granicus.if.org Git - postgresql/commit
Fix code that checks to see if an index can be considered to match the query's
authorTom Lane <tgl@sss.pgh.pa.us>
Sun, 29 Jan 2006 17:27:50 +0000 (17:27 +0000)
committerTom Lane <tgl@sss.pgh.pa.us>
Sun, 29 Jan 2006 17:27:50 +0000 (17:27 +0000)
commit2d98f462551f6bbc0935e531c06e2b4c064b5020
tree6a6c4a75ae95f120cf0104ebf8161ab0d3856b4c
parent18d69488587af4b7883de46847438de01282d8a3
Fix code that checks to see if an index can be considered to match the query's
requested sort order.  It was assuming that build_index_pathkeys always
generates a pathkey per index column, which was not true if implied equality
deduction had determined that two index columns were effectively equated to
each other.  Simplest fix seems to be to install an option that causes
build_index_pathkeys to support this behavior as well as the original one.
Per report from Brian Hirt.
src/backend/optimizer/path/indxpath.c
src/backend/optimizer/path/pathkeys.c
src/include/optimizer/paths.h