Re: CONVERT function is seriously broken

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: CONVERT function is seriously broken
Дата
Msg-id 200211020410.gA24AEV12318@candle.pha.pa.us
обсуждение исходный текст
Ответ на CONVERT function is seriously broken  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: CONVERT function is seriously broken  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
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@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073
 


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: Some questions about the NetWare Port - please comment
Следующее
От: Larry Rosenman
Дата:
Сообщение: Re: 7.3B3 psql talking to a 7.2.3 server?