Re: select cash_out('2'); crashes backend on 7.0.2

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: select cash_out('2'); crashes backend on 7.0.2
Дата
Msg-id 3219.976652747@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: select cash_out('2'); crashes backend on 7.0.2  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: pgsql-bugs@postgresql.org
Дата:
Сообщение: pqReadData() -- backend closed the channel unexpectedly
Следующее
От: Hiroshi Inoue
Дата:
Сообщение: Re: plpgsql function error after alter table add