anon.partial possibly not working with capitalized column names
Hello,
When partially replacing values in my table, I encountered an error I think is caused due to anon.partial not properly functioning with capitalization in the colnames, however I'm not 100% sure (quite new to working with postgres).
snippet I'm running:
SECURITY LABEL FOR anon ON COLUMN red."Redacted"."RedactedColName" IS 'MASKED WITH FUNCTION anon.partial(RedactedColName, 2, $$XXXXX$$, 2)';
When replacing the RedactedColName in my db to redactedcolname, things seemed to work (apart from different errors because I'm now missing a column). Additionally, things seem to work with other functions (e.g. anon.random_string)
the (redacted) error is as follows:
ERROR: column "redactedcolname" does not exist
LINE 1: ...E red."Redact" SET "RedactedColName " = anon.partial(RedactedCo...
^
HINT: Perhaps you meant to reference the column "Actor.RedactedColName".
QUERY: UPDATE red."Redact" SET "RedactedColName" = anon.partial(RedactedColName, 2, $$XXXXX$$, 2)
CONTEXT: PL/pgSQL function anon.anonymize_table(regclass) line 10 at EXECUTE
SQL function "anonymize_database" statement 1
SQL state: 42703```
Please let me know if you need more information.