Re: BUG #1381: invalid input syntax for integer: ""

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Nicolas Addington" <adding(at)math(dot)wisc(dot)edu>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #1381: invalid input syntax for integer: ""
Date: 2005-01-11 06:10:59
Message-ID: 12884.1105423859@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-www

"Nicolas Addington" <adding(at)math(dot)wisc(dot)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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2005-01-11 06:13:54 Re: pg_dump fails to set index ownership
Previous Message Michael Fuhr 2005-01-11 05:57:55 Re: pg_dump fails to set index ownership

Browse pgsql-www by date

  From Date Subject
Next Message Tom Lane 2005-01-11 06:27:02 Bug form version numbers
Previous Message Nicolas Addington 2005-01-11 05:28:30 BUG #1381: invalid input syntax for integer: ""