You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
I want to create a unique constraint on an encrypted column, but since it's :binary (which gets stored as bytea in Postgres), the unique index doesn't work as expected. I followed the _hash instructions, but that value is stored as :binary too, so has the same limitation. Am I'm missing something or is this functionality not supported? Is there a way to store the value as a base64 string instead of binary?
The text was updated successfully, but these errors were encountered:
therockstorm
changed the title
Create unique contraint for encrypted column
Create unique contraint for encrypted or hashed column
Jun 21, 2022
I want to create a unique constraint on an encrypted column, but since it's
:binary
(which gets stored asbytea
in Postgres), the unique index doesn't work as expected. I followed the_hash
instructions, but that value is stored as:binary
too, so has the same limitation. Am I'm missing something or is this functionality not supported? Is there a way to store the value as a base64 string instead of binary?The text was updated successfully, but these errors were encountered: