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
[EMAIL PROTECTED] | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
