I'm trying to run a Java Jetty application and I keep seeing 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 issue? I thought pgcrypt was prebundled in Postgres 9.1.x?
I currently run Mac OSX Lion 10.7 and installed Postgres using brew "brew install postgres".
I just had to enable pgcrypto; Just ran from the CLI:
CREATE EXTENSION pgcrypto;
For mac users I recommend reading more about it on brew:
brew info postgres
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With