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). -- rbt <at> sitesell <dot> com ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend