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

From Bruce Momjian
Subject Re: select cash_out('2'); crashes backend on 7.0.2
Date
Msg-id 200012122028.PAA08449@candle.pha.pa.us
Whole thread Raw
List pgsql-bugs
Added to TODO:

    * SELECT cash_out(2) crashes because of opaque

> 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
>


--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

pgsql-bugs by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: constrains of array
Next
From: Tom Lane
Date:
Subject: Re: plpgsql function error after alter table add