Re: Bug #939: Function parameter of type int2 fail when called.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: paulj(at)sonalysts(dot)com, pgsql-bugs(at)postgresql(dot)org
Subject: Re: Bug #939: Function parameter of type int2 fail when called.
Date: 2003-04-09 15:34:32
Message-ID: 7525.1049902472@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

pgsql-bugs(at)postgresql(dot)org writes:
> In version 7.2 we defined a bunch of functions with parameters of type int2. In version 7.2 this worked as advertised. We then upgraded to version 7.3.2. After upgrading we were not able to run any functions that had the int2 type as a parameter. When we tried to run one of those functions we got the following error message:

If you are calling the function with a simple literal constant, you need
to cast the constant to int2 explicitly; downconversion from int4 to
int2 is not automatic anymore.

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message pgsql-bugs 2003-04-10 01:08:58 Bug #940: encoding err? or mb support err???
Previous Message pgsql-bugs 2003-04-09 13:19:57 Bug #939: Function parameter of type int2 fail when called.