Re: BUG #1381: invalid input syntax for integer: "" - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #1381: invalid input syntax for integer: ""
Date
Msg-id 12884.1105423859@sss.pgh.pa.us
Whole thread Raw
In response to BUG #1381: invalid input syntax for integer: ""  ("Nicolas Addington" <adding@math.wisc.edu>)
List pgsql-bugs
"Nicolas Addington" <adding@math.wisc.edu> writes:
> PostgreSQL version: 8.0

tsk, tsk --- it's not 8.0.  Yet.

> When a pl/perl trigger for an insert event changes an integer column in the
> new row to null, it fails.  Interestingly, it doesn't have a problem if the
> column was originally null.

Looks like we have to check *both* SvOK() and SvTYPE() everywhere.
Sigh.  Done --- thanks for the report.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: pg_dump fails to set index ownership
Next
From: Tom Lane
Date:
Subject: Re: pg_dump fails to set index ownership