Re: CONVERT function is seriously broken

Tom Lane wrote:
> I have just noticed that the implementation of
> CONVERT(text USING encoding_name)
> tries to do database access during the grammar phase, viz it looks
> up the encoding_name in pg_conversion and replaces it with an OID.
>
> This is not workable; consider the situation where we are in an
> already-aborted transaction. Using a pg_conversion OID in stored rules
> isn't very acceptable either.
>
> Unfortunately, I don't see any way offhand to fix this without an
> initdb :-(.

Ooch, that hurts. How bad would it be if it was broken in 7.3?

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073