From: Scott Ribe <scott_ribe@elevated-dev.com>
To: Pepe TD Vo <pepevo@yahoo.com>
Cc: David G. Johnston <david.g.johnston@gmail.com>
Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Subject: Re: insert data with invalid input syntax for integer:"42P01"
Date: Mon, 11 Feb 2019 12:48:25 -0700
Message-ID: <89C6056F-E03F-4844-B454-B6868C9061E0@elevated-dev.com> (raw)
In-Reply-To: <2112371589.1866229.1549913142122@mail.yahoo.com>
References: <2112371589.1866229.1549913142122.ref@mail.yahoo.com>
<2112371589.1866229.1549913142122@mail.yahoo.com>
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, or have 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?
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: scott_ribe@elevated-dev.com, pepevo@yahoo.com, david.g.johnston@gmail.com, pgsql-admin@lists.postgresql.org
Subject: Re: insert data with invalid input syntax for integer:"42P01"
In-Reply-To: <89C6056F-E03F-4844-B454-B6868C9061E0@elevated-dev.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox