-
Bug
-
Resolution: Invalid
-
Normal
-
None
-
None
-
None
I get the following error on my Debian stable (squeeze) box:
DBD::Pg::st execute failed: ERROR: function musicbrainz_unaccent(character varying) does not exist LINE 1: SELECT regexp_replace(upper(substr(musicbrainz_unaccent( $1... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts. QUERY: SELECT regexp_replace(upper(substr(musicbrainz_unaccent( $1 ), 1, 6)), '[^A-Z ]', '_', 'g') CONTEXT: PL/pgSQL function "page_index" line 7 at assignment at /home/weisslj/src/musicbrainz-server/admin/replication/../../lib/Sql.pm line 103.
It works however on my Debian unstable box. I installed both postgresql extensions successfully, and they work when testing them manually:
$ psql -U musicbrainz musicbrainz_db musicbrainz_db=> select musicbrainz_unaccent('asd'); musicbrainz_unaccent ---------------------- asd (1 row)
How could I further test what is going wrong here?