Re: Bug in ALTER COLUMN/TYPE - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: Bug in ALTER COLUMN/TYPE
Date
Msg-id 200408061524.i76FO8904636@candle.pha.pa.us
Whole thread Raw
In response to Re: Bug in ALTER COLUMN/TYPE  (Rod Taylor <rbt@sitesell.com>)
List pgsql-hackers
Rod Taylor wrote:
> On Tue, 2004-08-03 at 23:36, Christopher Kings-Lynne wrote:
> > I think we need to deny changing column types if a function is using the 
> > table type as a return set.
> > 
> > test=# create table test (a int4);
> > CREATE TABLE
> > test=# create function test () returns setof test as 'select 1' language 
> > sql;
> 
> What we really need is dependencies within the function body and the
> ability to clear the function cache (recompile).

I notice we didn't have this on the TODO --- added:
* Track dependencies in function bodies and recompile/invalidate

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073
 


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Open items
Next
From: "Marc G. Fournier"
Date:
Subject: Re: Open items