Re: Bug? Insert into new Datatype 7.0.x

"Michael Miyabara-McCaskey" <mykarz(at)miyabara(dot)com> writes:
> I fumbled around for a while, but finally recreated table3 as (oid, text,
> text), and it worked fine... My question what caused the backend to crash?

> The data I was inserting into table3, was the actual oid from table2, column
> 2 and column 3 were number values of the form "x.xxx", or a null value.

It looks like the text-to-float4 converter function is not NULL-safe in
7.0.*. Sorry about that :-(.

7.1 fixes a boatload of problems of that ilk. In the meantime you could
kluge up something with a CASE expression that tests for null before
trying to cast to float4, or you could fix text_float4 to check for a
null input.

regards, tom lane