Re: pgsql 7.1: int4out() brokeness? - Mailing list pgsql-bugs

From Tom Lane
Subject Re: pgsql 7.1: int4out() brokeness?
Date
Msg-id 11354.979226248@sss.pgh.pa.us
Whole thread Raw
In response to pgsql 7.1: int4out() brokeness?  (James Troup <james@nocrew.org>)
List pgsql-bugs
James Troup <james@nocrew.org> writes:
>  | template1=# create table x (y int4); insert into x values (31); select y, int4out(y) from x;
>  | CREATE
>  | INSERT 34029 1
>  |  y  |  int4out
>  | ----+-----------
>  |  31 | 136420312
>  | (1 row)

The bug here is that the system allows you to invoke int4out at all.
It should not, because int4out doesn't return a value that can be
used for computation...

> int4out() seems to be broken which in turn breaks ODBC.

ODBC is broken for having ever used it in the first place.  This error
is repaired in the 7.0.3 and 7.1 releases of ODBC, btw.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Stanislas Pinte
Date:
Subject: Bad Integer N
Next
From: pgsql-bugs@postgresql.org
Date:
Subject: JDBC PreparedStatement.setMaxRows() affects other objects intantiated from this class and it's parent class