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

From Tom Lane
Subject Re: CONVERT function is seriously broken
Date
Msg-id 17803.1036213217@sss.pgh.pa.us
Whole thread Raw
In response to Re: CONVERT function is seriously broken  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: CONVERT function is seriously broken  (Bruce Momjian <pgman@candle.pha.pa.us>)
Re: CONVERT function is seriously broken  ("Marc G. Fournier" <scrappy@hub.org>)
List pgsql-hackers
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> Tom Lane wrote:
>> 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?

We could dike out the feature:

convert_list:           a_expr USING any_name               {                   elog(ERROR, "CONVERT(... USING ...) is
notimplemented");               }
 

Short of that, I think we need an initdb to change the function
signature for the convert() function.  It needs to take a (suitably
quoted) text parameter, not an OID.

Since we forced initdb only a week ago with beta3, I don't think there
is really a strong argument against doing it again.  But probably Marc
will say that we need a beta4 at this point, instead of going for RC1...
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: 7.2.3 vacuum bug
Next
From: Rod Taylor
Date:
Subject: Re: 7.3B3 psql talking to a 7.2.3 server?