Received: from localhost (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 4DE8E632A88 for ; Thu, 22 Oct 2009 12:47:31 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 78817-10 for ; Thu, 22 Oct 2009 15:47:20 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by mail.postgresql.org (Postfix) with ESMTP id 81FE062DBFD for ; Thu, 22 Oct 2009 12:47:20 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id n9MFlEVG001190; Thu, 22 Oct 2009 11:47:14 -0400 (EDT) To: Richard Huxton cc: Denis BUCHER , pgsql-sql@postgresql.org Subject: Re: Problem with return type of function ??? (corrected) In-reply-to: <4AE07507.5050900@archonet.com> References: <4AE046E4.8010205@hsolutions.ch> <29935.1256222015@sss.pgh.pa.us> <4AE07507.5050900@archonet.com> Comments: In-reply-to Richard Huxton message dated "Thu, 22 Oct 2009 16:06:47 +0100" Date: Thu, 22 Oct 2009 11:47:13 -0400 Message-ID: <1189.1256226433@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.561 tagged_above=-10 required=5 tests=AWL=0.038, BAYES_00=-2.599 X-Spam-Level: X-Archive-Number: 200910/109 X-Sequence-Number: 33308 Richard Huxton 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