Thread: BUG #3972: ERROR: function 59015 returned NULL

The following bug has been logged online:

Bug reference:      3972
Logged by:          Maxime Carbonneau
Email address:      manitou@maikan.com
PostgreSQL version: 8.2.6
Operating system:   Linux
Description:        ERROR:  function 59015 returned NULL
Details:

with a database encoded with UTF8, I cannot insert into a varchar(100)
column the letter œ (\u0x0153). It gives me: "ERROR:  function 59015
returned NULL"

Maxime Carbonneau wrote:

> with a database encoded with UTF8, I cannot insert into a varchar(100)
> column the letter œ (\u0x0153). It gives me: "ERROR:  function 59015
> returned NULL"

What's function 59015?  Try a
select proname from pg_proc where oid = 59015;

--
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

Thanks for the reply.
The error was inside a personal function that called function convert=20=20
with caracters that it cannot handle properly.
"select proname from pg_proc where oid =3D 59015;" did not give me any=20=
=20
result. I still don't know where "59015" come from, but I'm not in a=20=20
hurry to find it right now :-)

Thanks
Maxime

Le 08-02-20 =E0 07:19, Alvaro Herrera a =E9crit :

> Maxime Carbonneau wrote:
>
>> with a database encoded with UTF8, I cannot insert into a varchar=20
>> (100)
>> column the letter =9C (\u0x0153). It gives me: "ERROR:  function "
>> returned NULL"
>
> What's function 59015?  Try a
> select proname from pg_proc where oid =3D 59015;
>
> --=20
> Alvaro Herrera                                http://=20
> www.CommandPrompt.com/
> The PostgreSQL Company - Command Prompt, Inc.