Re: CONVERT function is seriously broken - Mailing list pgsql-hackers

From Tatsuo Ishii
Subject Re: CONVERT function is seriously broken
Date
Msg-id 20021103.104956.77328650.t-ishii@sra.co.jp
Whole thread Raw
In response to CONVERT function is seriously broken  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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


pgsql-hackers by date:

Previous
From: Philip Warner
Date:
Subject: Re: Optimizer Question/Suggestion
Next
From: Tom Lane
Date:
Subject: Re: Optimizer Question/Suggestion