Re: invalid memory alloc after insert with c trigger function

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: invalid memory alloc after insert with c trigger function
Дата
Msg-id 23888.1180704842@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: invalid memory alloc after insert with c trigger function  (Dudás József <dj1999@freemail.hu>)
Ответы Re: invalid memory alloc after insert with c trigger function  (Dudás József <dj1999@freemail.hu>)
Список pgsql-general
=?ISO-8859-2?Q?Dud=E1s_J=F3zsef?= <dj1999@freemail.hu> writes:
> Just have problem with this conversion from TEXT - double - Datum (
> NUMERIC ) where in TEXT is a number value forexample now the value is 1.00

NUMERIC?  You didn't say anything about NUMERIC before.  The code you
posted thinks it is working with a FLOAT8 datum, which is just about
entirely unlike NUMERIC.  If you are trying to assign that to a table
column that's declared as NUMERIC, then that type mismatch is exactly
your problem.

            regards, tom lane

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

Предыдущее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: invalid memory alloc after insert with c trigger function
Следующее
От: Csaba Nagy
Дата:
Сообщение: Autovacuum keeps vacuuming a table disabled in pg_autovacuum