Re: insert data with invalid input syntax for integer:"42P01" - Mailing list pgsql-admin

From Scott Ribe
Subject Re: insert data with invalid input syntax for integer:"42P01"
Date
Msg-id 89C6056F-E03F-4844-B454-B6868C9061E0@elevated-dev.com
Whole thread Raw
In response to insert data with invalid input syntax for integer:"42P01"  (Pepe TD Vo <pepevo@yahoo.com>)
List pgsql-admin
your trigger is defined to call cidr_staging.trigger_fct_tr_stg_adjudicative_status_ins, the error is report from
there,but you give a definition for cidr_staging.trigger_fct_tr_stg_adjudicative_status_in, is that a copy/paste error,
orhave you actually posted the definition of a different procedure than the one in question? 

> even I take the "E" values out the error is still occurred but if I dropped the function and trigger, the insert is
fine

One more time: ***WHY*** are doing that?



pgsql-admin by date:

Previous
From: Pepe TD Vo
Date:
Subject: insert data with invalid input syntax for integer:"42P01"
Next
From: "David G. Johnston"
Date:
Subject: Re: insert data with invalid input syntax for integer:"42P01"