"D'Arcy J.M. Cain" <darcy@druid.net> writes:
> Hmm. I did give it a harder look and look what jumped out. Both
> chkpass_out and chkpass_rout return PG_RETURN_CSTRING but chkpass_out
> builds a standard c string while chkpass_rout builds a variable text
> structure. That can't be right.
It's not, but chkpass_rout is declared to return text, so it should be
saying PG_RETURN_TEXT_P. It turns out both macros do the same thing,
so this is just a cosmetic issue.
> Oh, one more datapoint - the error only happens on vacuum analyze, not just
> vacuum. Not sure what that means exactly.
That is odd. You only have the chkpass operators shown in the contrib
module, right? No "chkpass = chkpass" operator? Without one, vacuum
analyze should pretty much ignore the chkpass column ...
regards, tom lane