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 13:00:36 -0700
Message-ID: <741DB90F-6C7A-4AEA-B2EB-DD37C5529AF4@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>
> On Feb 11, 2019, at 12:25 PM, Pepe TD Vo <pepevo@yahoo.com> wrote:
>
> insert into cidrmgmt.errorlog(...)
For what it's worth, it seems likely the error is coming from that line (assuming you posted the correct procedure definition), thus that's the table whose definition matters. Further, the bad value is likely coming from the context, and there's no info here that would help figure out why there's "42P01" where an integer is required. But I can tell you that PG's nearest equivalent of Oracle's sys_context is untyped, always a string, so there would have to be a cast to an integer type. But of course you can't cast 42P01 to an integer, so that has to be figured out first.
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: <741DB90F-6C7A-4AEA-B2EB-DD37C5529AF4@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