CreateFunctions.sql Error

[AEtherSurfer]

Postgres 9.1 on Ubuntu 12.04

postgres@Acoustid:/home/datasurfer/acoustid-server$ ./run_psql.sh <sql/CreateFunctions.sql

CREATE FUNCTION
ERROR:  operator does not exist: integer[] - integer
LINE 3:     SELECT uniq(sort(subarray($1 - 627964279,
                                         ^
HINT:  No operator matches the given name and argument type(s). You might need to add explicit type casts.
CREATE FUNCTION
ERROR:  function digest(text, unknown) does not exist
LINE 3:     SELECT digest($1::text, 'sha1');
                   ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.

[AEtherSurfer]

http://www.postgresql.org/docs/current/static/sql-createextension.html http://www.postgresql.org/docs/current/static/contrib.html

[umask]

We are using PostgreSQL 9.1:

-bash-4.1$ psql -U postgres acoustid < /usr/pgsql-9.1/share/extension/intarray--1.0.sql Use "CREATE EXTENSION intarray" to load this file. -bash-4.1$ psql psql (9.1.3) Type "help" for help.

postgres=# \c acoustid You are now connected to database "acoustid" as user "postgres". acoustid=# CREATE EXTENSION intarray; CREATE EXTENSION