diff options
author | Tom Lane <tgl@sss.pgh.pa.us> | 2007-01-03 22:39:35 +0000 |
---|---|---|
committer | Tom Lane <tgl@sss.pgh.pa.us> | 2007-01-03 22:39:35 +0000 |
commit | f532a22a8f36ee61f7de601d8d6eda1c73cf3ed8 (patch) | |
tree | eede56887a4f4fa0310ff16605c3c9aebca49f60 /src/backend/tcop/postgres.c | |
parent | 32d029573d0b0908a18377959a835d7e17171fc2 (diff) | |
download | postgresql-f532a22a8f36ee61f7de601d8d6eda1c73cf3ed8.tar.gz postgresql-f532a22a8f36ee61f7de601d8d6eda1c73cf3ed8.zip |
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.
Diffstat (limited to 'src/backend/tcop/postgres.c')
0 files changed, 0 insertions, 0 deletions