Unable to convert character varying to text
I am trying to user your Extension to provide in built anonymization. I created the below table and I am trying to mask the PII columns
Table "scott.emp"
Column | Type | Modifiers
-------------+------------------------+-----------
empno | integer |
mgrno | integer |
designation | character varying(50) |
salary | double precision |
garm | character(1) |
email | character varying(100) |
first_name | character varying(20) |
last_name | character varying(20) |
testmasking=# COMMENT ON COLUMN scott.emp.email IS 'MASKED WITH FUNCTION anon.random_email()';
ERROR: cannot change data type of view column "email" from character varying(100) to text
Edited by damien clochard