cast needed - but where and why?

Поиск
Список
Период
Сортировка
От Steve Clark
Тема cast needed - but where and why?
Дата
Msg-id 49D4D396.6070601@netwolves.com
обсуждение исходный текст
Ответы Re: cast needed - but where and why?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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
character146 
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

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

Предыдущее
От: linnewbie
Дата:
Сообщение: Re: Posgres Adding braces at beginning and end of text (html) content
Следующее
От: SHARMILA JOTHIRAJAH
Дата:
Сообщение: Re: How to find the query completeion time?