BUG #4364: type of "new.id" does not match that when preparing the plan

From: "Alexander Kirpa" <postgres(at)bilteks(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #4364: type of "new.id" does not match that when preparing the plan
Date: 2008-08-19 18:14:25
Message-ID: 200808191814.m7JIEPS7092748@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 4364
Logged by: Alexander Kirpa
Email address: postgres(at)bilteks(dot)com
PostgreSQL version: 8.3.1
Operating system: FreeBSD 7.0
Description: type of "new.id" does not match that when preparing the
plan
Details:

After change column type from integer to smallint
trigger function generate next error
----------
2008-08-19 20:50:30 EEST 42945 ERROR: type of "new.id" does not match that
when preparing the plan
2008-08-19 20:50:30 EEST 42945 CONTEXT: PL/pgSQL function
"job_tf_after_update" line 3 at IF
2008-08-19 20:50:30 EEST 42945 STATEMENT: UPDATE job SET
processid=43057,job_starttime=now() WHERE id=2
----------- error line in trigger
IF NOT EQ(NEW.id,OLD.id) THEN
RAISE EXCEPTION 'UPDATE id NOT ALLOWED';
END IF;
-----------
Workaround: touch trigger function

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2008-08-19 18:57:55 Re: BUG #4340: SECURITY: Is SSL Doing Anything?
Previous Message Magnus Hagander 2008-08-19 18:12:47 Re: BUG #4340: SECURITY: Is SSL Doing Anything?