Function pgp_sym_encrypt(numeric, unknown) does not exist

Question

I am using https://github.com/incuna/django-pgcrypto-fields for pgcrypto in my Django project. It's working fine with inserting, updating fields. But when I am trying something like

MyTable.objects.filter(some_code=somecode).update(
                    some_value=some_price * F('some_units'),
                    updated_on=datetime.now()
                )

Its throwing me psycopg2.errors.UndefinedFunction: function pgp_sym_encrypt(numeric, unknown) does not exist

Any help would be great. Thanks :)

Answer 1

To use pgcrypto functions, the pgcrypto extension must be created in the database.

$  psql mydbname -c 'CREATE EXTENSION pgcrypto;'
CREATE EXTENSION
$  psql mydbname -c '\dx'
                            List of installed extensions
   Name    | Version |   Schema   |                   Description                   
-----------+---------+------------+-------------------------------------------------
 pgcrypto  | 1.3     | public     | cryptographic functions
...