Re: invalid memory alloc after insert with c trigger function

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: dj1999(at)freemail(dot)hu
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: invalid memory alloc after insert with c trigger function
Date: 2007-06-01 13:34:02
Message-ID: 23888.1180704842@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

=?ISO-8859-2?Q?Dud=E1s_J=F3zsef?= <dj1999(at)freemail(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Csaba Nagy 2007-06-01 13:34:22 Autovacuum keeps vacuuming a table disabled in pg_autovacuum
Previous Message Martijn van Oosterhout 2007-06-01 13:21:42 Re: invalid memory alloc after insert with c trigger function