function soundex(character varying) does not exist
|Reported by:||mikem||Owned by:||robe|
|Keywords:||function soundex exist||Cc:||mpaul|
Version info: "PostgreSQL 9.2.4 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.4.7 20120313 (Red Hat 4.4.7-3), 64-bit POSTGIS="2.1.0 r11822" GEOS="3.4.2-CAPI-1.8.2 r3921" PROJ="Rel. 4.8.0, 6 March 2012" GDAL="GDAL 1.9.2, released 2012/10/08" LIBXML="2.7.6" LIBJSON="UNKNOWN" RASTER"
@ http://postgis.net/install, I am following the "Getting Started" > "Enabling PostGIS" > "Run the following SQL" instructions.
The last successful instruction I can execute is "CREATE EXTENSION fuzzystrmatch;"
The next statement fails "CREATE EXTENSION postgis_tiger_geocoder"
The message is: ERROR: function soundex(character varying) does not exist SQL state: 42883 Hint: No function matches the given name and argument types. You might need to add explicit type casts. Character: 56874
Background: I was able to successfully execute all CREATE EXTENTION commands before when I was using, and had, the "public" schema which is included in a default installation. Having followed recommendations to remove the "public" schema, I removed these extensions and dropped the "public" schema. Then I created a "postgis2" schema, set my search_path to it and for good measure altered my login to default to the new "postgis2" schema. Then started executing the CREATE EXTENSION commands again and got stuck as noted above. I have verified that function soundex(text) exist in my new "postgis2" schema along with 1058 other functions.
The only change from when this worked to when it broke is that when it worked, the installation schema was the "public" schema and it does not work when the public schema is dropped and I install use a custom schema.
I tried to resolve the issue by reverting with: drop extension fuzzystrmatch cascade; drop extension postgis_topology cascade; drop extension postgis cascade; drop schema postgis2 cascade; create schema public; set search_path to public; alter user michael set search_path to public; CREATE EXTENSION postgis; CREATE EXTENSION postgis_topology; CREATE EXTENSION fuzzystrmatch; CREATE EXTENSION postgis_tiger_geocoder;
… but the problem persists.