On Fri, Aug 11, 2000 at 10:07:39PM +0200, Louis-David Mitterrand wrote:
> On Fri, Aug 11, 2000 at 11:42:06AM -0400, Tom Lane wrote:
> > Louis-David Mitterrand <cunctator@apartia.ch> writes:
> > > Strangely engough the function call works fine when called from psql but
> > > fails (but not always!) from a C trigger.
> >
> > May we see the C trigger? I'm suspicious it's doing something wrong...
> >
>
> Please find the trigger attached to this message as well as the .sql
> file containing the full DB schema including the functions. Here is a
> typicall log entry of the error:
Finally I found the problem:
bindtextdomain("apartia_com", "/usr/local/auction/locale");
textdomain("apartia_com");
setlocale(LC_ALL, seller_locale);
When "seller_locale" is, for instance, "de_DE", then I get theses
errors:
ERROR: Bad float8 input format '0.05'
Is Postgres expecting the float as 0,05 (notice the comma) because of
the locale?
When "seller_locale" is "en_US" all is well.
(C trigger is attached)
--
Louis-David Mitterrand - ldm@apartia.org - http://www.apartia.org
"When I give food to the poor I am called a saint, when I ask why
they go hungry I am called a communist"
--Bishop Helder Camara
