Re: [GENERAL] PL/pgSQL Function Help - Mailing list pgsql-bugs

From Tom Lane
Subject Re: [GENERAL] PL/pgSQL Function Help
Date
Msg-id 25059.1136328604@sss.pgh.pa.us
Whole thread Raw
In response to Re: [GENERAL] PL/pgSQL Function Help  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
I wrote:
> Michael Fuhr <mike@fuhr.org> writes:
>> I get an assertion failure if rec is declared as a record but not
>> if it's declared as a test_type.  And only in 8.0.5, not in 8.1.1
>> or 8.2devel.

> I find that the lack of an assertion failure in 8.1 is a happenstance of
> unrelated changes.  The problem is that plpgsql is making no effort at
> all to ensure that the record type it returns is the same as it's
> declared to return.

Patches committed to check this in 8.0 and up.  7.4 and 7.3 seem not to
have an issue.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Jaime Casanova
Date:
Subject: Re: BUG #2139: Problem when calling functions without any argument
Next
From: Tom Lane
Date:
Subject: Re: Small bug fix in readline promt handling