Re: tsearch2() trigger and domain types... - Mailing list pgsql-sql

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