Re: CONVERT function is seriously broken

From: Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp>
To: tgl(at)sss(dot)pgh(dot)pa(dot)us
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: CONVERT function is seriously broken
Date: 2002-11-03 01:49:56
Message-ID: 20021103.104956.77328650.t-ishii@sra.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> 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 :-(.

Sorry for the trouble and thanks for the fix.
--
Tatsuo Ishii

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2002-11-03 04:43:09 Re: Optimizer Question/Suggestion
Previous Message Philip Warner 2002-11-03 01:30:15 Re: Optimizer Question/Suggestion