1- This directory containsthree SQL scripts that control use of some new
1+ This directory containstwo SQL scripts that control use of some new
22code for planning/optimizing queries containing LIKE and
33regular-expression operators. This code was added to Postgres 7.0 late in
44beta test, and it hasn't gotten enough testing to warrant turning it on by
@@ -11,7 +11,7 @@ queries involving LIKE or regexps in WHERE clauses.
1111HOW TO USE THE SCRIPTS
1212----------------------
1313
14- All three scripts must be run as the Postgres superuser. The easiest
14+ Both scripts must be run as the Postgres superuser. The easiest
1515way to run an SQL script is
1616psql -f scriptfile databasename
1717or you can start psql interactively and enter
@@ -25,13 +25,6 @@ disablelike.sql reverts to the old planning code for LIKE, in the database
2525in which it is run. If you run it in template1, all subsequently-created
2626databases will use the old code by default.
2727
28- If your database was initdb'd with release 7.0beta5, you need to run
29- updatepgproc.sql before you can run enablelike.sql. Databases initdb'd
30- with 7.0RC1 or later already have pg_proc entries for the new code, so
31- updatepgproc.sql is unnecessary for them. If enablelike.sql produces
32- errors like "No procedure with name regexeqsel", then you need to run
33- updatepgproc.sql.
34-
3528
3629WHAT IT DOES
3730------------