pgsql: Fix regex_fixed_prefix() to cope reasonably well with regex - Mailing list pgsql-committers

Log Message:
-----------
Fix regex_fixed_prefix() to cope reasonably well with regex patterns of the
form '^(foo)$'.  Before, these could never be optimized into indexscans.
The recent changes to make psql and pg_dump generate such patterns (for \d
commands and -t and related switches, respectively) therefore represented
a big performance hit for people with large pg_class catalogs, as seen in
recent gripe from Erik Jones.  While at it, be more paranoid about
case-sensitivity checking in multibyte encodings, and fix some other
corner cases in which a regex might be interpreted too liberally.

Tags:
----
REL7_4_STABLE

Modified Files:
--------------
    pgsql/src/backend/utils/adt:
        regexp.c (r1.49.4.3 -> r1.49.4.4)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/regexp.c.diff?r1=1.49.4.3&r2=1.49.4.4)
        selfuncs.c (r1.147.2.4 -> r1.147.2.5)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/selfuncs.c.diff?r1=1.147.2.4&r2=1.147.2.5)
    pgsql/src/include/utils:
        builtins.h (r1.228.2.1 -> r1.228.2.2)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/utils/builtins.h.diff?r1=1.228.2.1&r2=1.228.2.2)