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

From Marc G. Fournier
Subject Re: CONVERT function is seriously broken
Date
Msg-id 20021102065818.M42511-100000@hub.org
Whole thread Raw
In response to Re: CONVERT function is seriously broken  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Sat, 2 Nov 2002, Tom Lane wrote:

> 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 not implemented");
>                 }
>
> 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...

Most definitely ... but beta3 was nice and short, and no reason why beta4
can't be as well ...




pgsql-hackers by date:

Previous
From: Philip Warner
Date:
Subject: Re: Optimizer Question/Suggestion - numbers after
Next
From: Tom Lane
Date:
Subject: Re: "Cache lookup failed for relation 16905" ??