Geek asks and answers

Postgres missing pgcrypt ability?

I am trying to run a Java Jetty application and I see this error:

Caused by: 
org.postgresql.util.PSQLException: ERROR: function crypt(character varying, character) does not exist|  Hint: No function matches the given name and argument types. You might need to add explicit type casts.|  Where: PL/pgSQL function

Does anyone recognize this or how to solve the problem? I thought pgcrypt was added in Postgres 9.1.x?

I am currently running Mac OSX Lion 10.7 and installing Postgres using brew "brew install postgres".

+5
source share
2 answers

I just had to enable pgcrypto; Just ran from the CLI:

CREATE EXTENSION pgcrypto;

For Mac users, I recommend reading more about this on brew:

brew info postgres

+12
source

This is an extension, not an "extension." Since I cannot edit a single character, I had to post a new answer.

CREATE EXTENSION pgcrypto;
0
source

More articles:


All Articles