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 14250.1256249309@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:
> "Tom" == Tom Lane <tgl@sss.pgh.pa.us> writes:
>  Tom> The conversion itself is dependent on changeable catalog
>  Tom> entries, ie, pg_conversion.  So "stable" seems the appropriate
>  Tom> marking to me.

> That sounds like a bit of a stretch to me... we treat lots of stuff as
> immutable which is actually easier to change than pg_conversion entries
> (OS locale definitions for example).

Um ... locale *is* fixed within a given database, or at least LC_COLLATE
and LC_CTYPE are.  If you see cases where we have this wrong, they may
need to be revisited.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Andrew Gierth
Date:
Subject: Re: BUG #5126: convert_to preventing index scan
Next
From: Andrew Gierth
Date:
Subject: Re: BUG #5126: convert_to preventing index scan