hi!
I create hash partitions by column of character varying(40) ,then i query through the partition key,an error occurs like this:
ERROR: missing comparison function for types text & character varying
my statement is select * from tb_idm_mapping where auid = 'Zpm6sMkqF8ScmD9C6Kgn',
and auid is the partition key.
my pg version is postgresql-9.6.0.