Re: BUG #5126: convert_to preventing index scan

Andrew Gierth <andrew@tao11.riddles.org.uk> writes:
>  Peter> You haven't told us how the convert_to function is defined.

> convert_to is a builtin function. If there's a bug here, it's that
> convert_to is defined as stable rather than immutable. (Sure it depends
> on server_encoding, but that can't exactly change... if there's any
> other reason why it's not immutable, I can't think what it is.)

The conversion itself is dependent on changeable catalog entries,
ie, pg_conversion.  So "stable" seems the appropriate marking to me.

            regards, tom lane