Re: BUG #5126: convert_to preventing index scan

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk>
Cc: peter_e(at)gmx(dot)net (Peter Eisentraut), Roman Kapusta <roman(dot)kapusta(at)gmail(dot)com>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #5126: convert_to preventing index scan
Date: 2009-10-22 22:08:29
Message-ID: 14250.1256249309@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk> writes:
> "Tom" == Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Andrew Gierth 2009-10-22 22:30:49 Re: BUG #5126: convert_to preventing index scan
Previous Message Andrew Gierth 2009-10-22 21:14:38 Re: BUG #5126: convert_to preventing index scan