Tom Lane wrote:
Madison Kelly <[EMAIL PROTECTED]> writes:

  Can anyone see why the index might not be being used?


You didn't initdb in 'C' locale.  You can either re-initdb,
or create a specialized index with a non-default operator class
to support LIKE.  See the documentation.

                        regards, tom lane

I'll look into the non-default op class. I want to keep anything that tweaks the DB in my code so that a user doesn't need to modify anything on their system.

Thanks!

Madison

--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Madison Kelly (Digimer)
TLE-BU, The Linux Experience; Back Up
http://tle-bu.thelinuxexperience.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Reply via email to