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

From: Richard Huxton <dev(at)archonet(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
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:06:47
Message-ID: 4AE07507.5050900@archonet.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Tom Lane wrote:
> Denis BUCHER <dbucherml(at)hsolutions(dot)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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Denis BUCHER 2009-10-22 15:15:20 Re: Problem with return type of function ??? (corrected)
Previous Message Richard Huxton 2009-10-22 14:58:42 Re: Problem with return type of function ???