Re: [GENERAL] PL/pgSQL Function Help

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Michael Fuhr <mike(at)fuhr(dot)org>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: [GENERAL] PL/pgSQL Function Help
Date: 2006-01-03 22:50:04
Message-ID: 25059.1136328604@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-general

I wrote:
> Michael Fuhr <mike(at)fuhr(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2006-01-03 23:33:50 Re: Small bug fix in readline promt handling
Previous Message Jaime Casanova 2006-01-03 20:47:25 Re: BUG #2139: Problem when calling functions without any argument

Browse pgsql-general by date

  From Date Subject
Next Message Greg Stark 2006-01-03 23:19:12 Re: generic way to retrieve array as rowset
Previous Message Michael Glaesemann 2006-01-03 22:25:58 Re: When it is better to use "timestamp without time zone"?