Re: Problem with return type of function ??? (corrected) - Mailing list pgsql-sql

From Richard Huxton
Subject Re: Problem with return type of function ??? (corrected)
Date
Msg-id 4AE07507.5050900@archonet.com
Whole thread Raw
In response to Re: Problem with return type of function ??? (corrected)  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Problem with return type of function ??? (corrected)  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
Tom Lane wrote:
> Denis BUCHER <dbucherml@hsolutions.ch> writes:
> 
> Does that table have any dropped columns?  If you don't remember
> whether you ever dropped any columns, a quick look into pg_attribute
> will tell you:
> select attname from pg_attribute where attrelid = 'rma.serial_number'::regclass;
> 
> 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.

--  Richard Huxton Archonet Ltd


pgsql-sql by date:

Previous
From: Richard Huxton
Date:
Subject: Re: Problem with return type of function ???
Next
From: Denis BUCHER
Date:
Subject: Re: Problem with return type of function ??? (corrected)