Re: select cash_out('2'); crashes backend on 7.0.2 - Mailing list pgsql-bugs

From Tom Lane
Subject Re: select cash_out('2'); crashes backend on 7.0.2
Date
Msg-id 3219.976652747@sss.pgh.pa.us
Whole thread Raw
In response to Re: select cash_out('2'); crashes backend on 7.0.2  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-bugs
Bruce Momjian <pgman@candle.pha.pa.us> writes:
>> cascade=> select cash_out(2);
>> pqReadData() -- backend closed the channel unexpectedly.

> I can confirm this is crashes in 7.1 too.

You can get this sort of result with almost any input or output function
:-(.  The problem is that they're mostly misdeclared to take type
"opaque", which for no good reason is also considered to mean "accepts
any input type whatever", which means you can pass a value of any type
at all to an input or output function.

There have been some past discussions about introducing a little more
rigor into the type system's handling of I/O functions, but it ain't
gonna happen for 7.1 ...

            regards, tom lane

pgsql-bugs by date:

Previous
From: pgsql-bugs@postgresql.org
Date:
Subject: pqReadData() -- backend closed the channel unexpectedly
Next
From: Hiroshi Inoue
Date:
Subject: Re: plpgsql function error after alter table add