Re: BUG #5126: convert_to preventing index scan - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #5126: convert_to preventing index scan
Date
Msg-id 1396.1256227170@sss.pgh.pa.us
Whole thread Raw
In response to Re: BUG #5126: convert_to preventing index scan  (Andrew Gierth <andrew@tao11.riddles.org.uk>)
Responses Re: BUG #5126: convert_to preventing index scan
List pgsql-bugs
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

pgsql-bugs by date:

Previous
From: flamin dragon
Date:
Subject: Re: BUG #5130: Failed to run initdb:1
Next
From: Robert Haas
Date:
Subject: Re: 答复: 答复: [BUGS] Encounter shared memory error when running createlang command!