Re: Problem with return type of function ??? (corrected)

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Richard Huxton <dev(at)archonet(dot)com>
Cc: Denis BUCHER <dbucherml(at)hsolutions(dot)ch>, pgsql-sql(at)postgresql(dot)org
Subject: Re: Problem with return type of function ??? (corrected)
Date: 2009-10-22 15:47:13
Message-ID: 1189.1256226433@sss.pgh.pa.us
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Richard Huxton <dev(at)archonet(dot)com> writes:
> Tom Lane wrote:
>> plpgsql isn't tremendously good with rowtypes that contain dropped
>> columns.

> I thought that only applied to columns dropped after the function was
> defined. Live and learn.

There are/were some variants that go away if you recreate the function
or start a fresh session (to clear the compiled-function cache). Not
all, unfortunately.

regards, tom lane

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2009-10-22 15:51:34 Re: Problem with return type of function ??? (corrected)
Previous Message Denis BUCHER 2009-10-22 15:15:20 Re: Problem with return type of function ??? (corrected)