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 741DB90F-6C7A-4AEA-B2EB-DD37C5529AF4@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
> 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,
andthere's no info here that would help figure out why there's "42P01" where an integer is required. But I can tell you
thatPG's nearest equivalent of Oracle's sys_context is untyped, always a string, so there would have to be a cast to an
integertype. But of course you can't cast 42P01 to an integer, so that has to be figured out first. 



pgsql-admin by date:

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