cast needed - but where and why?

From: Steve Clark <sclark(at)netwolves(dot)com>
To: pgsql <pgsql-general(at)postgresql(dot)org>
Subject: cast needed - but where and why?
Date: 2009-04-02 15:02:46
Message-ID: 49D4D396.6070601@netwolves.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello list,

I am getting the following error after upgrading from 7.4.6 to 8.3.6
and can't figure out what is wrong. Any help would be greatly appreciated.

from our program:
sqlcode=-400 errmsg='column "event_ref_log_no" is of type integer but expression is of type text' in line 4138.

from pg_log:
2009-04-02 10:45:10 EDT:srm2api:ERROR: column "event_ref_log_no" is of type integer but expression is of type text at character 146
2009-04-02 10:45:10 EDT:srm2api:HINT: You will need to rewrite or cast the expression.
2009-04-02 10:45:10 EDT:srm2api:STATEMENT: insert into t_unit_event_log ( event_log_no , unit_serial_no , event_type
, event_category , event_mesg , event_severity , event_status , event_ref_log_no , event_logged_by , event_date ,
alarm , last_updated_by , last_updated_date ) values ( nextval ( 'seq_event_log_no' ) , $1 , $2 , $3 , $4 , $
5 , $6 , case when $7 > 0 then $8 else null end , current_user , now () , $9 , current_user , now () )

from our program:
exec sql begin declare section;
int h_cnt = 0;
int h_event_ref_log_no = NULL;
...
// insert into uel
exec sql insert into t_unit_event_log
(event_log_no,
unit_serial_no,
event_type,
event_category,
event_mesg,
event_severity,
event_status,
event_ref_log_no,
event_logged_by,
event_date,
alarm,
last_updated_by,
last_updated_date)
values (nextval('seq_event_log_no'),
:h_serial_no,
:h_type,
:h_category,
:h_mesg,
:h_sev,
:h_status,
case when :h_event_ref_log_no > 0
then :h_event_ref_log_no
else null end,
current_user,
now(),
:h_alarm,
current_user,
now());

Thanks,
Steve

Responses

Browse pgsql-general by date

  From Date Subject
Next Message linnewbie 2009-04-02 15:06:36 Re: Posgres Adding braces at beginning and end of text (html) content
Previous Message Leif B. Kristensen 2009-04-02 14:53:36 Re: How to find the query completeion time?