Make all comparisons done for/with statistics use the default collation.
authorTom Lane <tgl@sss.pgh.pa.us>
Sat, 12 Mar 2011 21:30:36 +0000 (16:30 -0500)
committerTom Lane <tgl@sss.pgh.pa.us>
Sat, 12 Mar 2011 21:30:36 +0000 (16:30 -0500)
commit696d1f7f064402840a60b7177a838d1452ad13e6
tree0882ce66927accc0060be2e8479b358374aa5aa7
parent94fe9c0f4e1672ccd830cb0aa7fd5ccce97d14ae
Make all comparisons done for/with statistics use the default collation.

While this will give wrong answers when estimating selectivity for a
comparison operator that's using a non-default collation, the estimation
error probably won't be large; and anyway the former approach created
estimation errors of its own by trying to use a histogram that might have
been computed with some other collation.  So we'll adopt this simplified
approach for now and perhaps improve it sometime in the future.

This patch incorporates changes from Andres Freund to make sure that
selfuncs.c passes a valid collation OID to any datatype-specific function
it calls, in case that function wants collation information.  Said OID will
now always be DEFAULT_COLLATION_OID, but at least we won't get errors.
src/backend/commands/analyze.c
src/backend/optimizer/path/costsize.c
src/backend/utils/adt/selfuncs.c
src/include/commands/vacuum.h
src/include/utils/selfuncs.h