Re: problem with float8 input format

Поиск
Список
Период
Сортировка
От Louis-David Mitterrand
Тема Re: problem with float8 input format
Дата
Msg-id 20000811220739.A3174@styx
обсуждение исходный текст
Ответ на Re: problem with float8 input format  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: problem with float8 input format  (Tom Lane <tgl@sss.pgh.pa.us>)
solution! (was: Re: problem with float8 input format)  (Louis-David Mitterrand <cunctator@apartia.ch>)
Список pgsql-general
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:

    000811.18:02:03.555  [1673] query:
    SELECT incr(max_price($1),0.05)

    000811.18:02:03.556  [1673] ERROR:  Bad float8 input format '0.05'

Thanks for your help,

--
Louis-David Mitterrand - ldm@apartia.org - http://www.apartia.org

                      Slight disorientation after prolonged system
                      uptime is normal for new Linux users. Please do
                      not adjust your browser.

Вложения

В списке pgsql-general по дате отправления:

Предыдущее
От: Dan Moschuk
Дата:
Сообщение: Re: Postgres problems with large databases.
Следующее
От: Ned Lilly
Дата:
Сообщение: tools and apps for PostgreSQL