manchicken <manchicken@notsosoft.net> writes:
> Is there any way to cast these column datatypes in the trigger to fool it,
No, you'd have to modify the trigger source code. It'd be a pretty
trivial change to allow domains over textual types:
continue; } oidtype = SPI_gettypeid(rel->rd_att, numattr);
+ oidtype = getBaseType(oidtype); /* We assume char() and varchar() are binary-equivalent to text */ if
(!(oidtype== TEXTOID || oidtype == VARCHAROID || oidtype == BPCHAROID)) { elog(WARNING,
"TSearch:'%s' is not of character type", trigger->tgargs[i]);
regards, tom lane