Re: plan invalidation vs stored procedures
От | Hannu Krosing |
---|---|
Тема | Re: plan invalidation vs stored procedures |
Дата | |
Msg-id | 1218025214.9188.22.camel@huvostro обсуждение исходный текст |
Ответ на | Re: plan invalidation vs stored procedures ("Pavel Stehule" <pavel.stehule@gmail.com>) |
Ответы |
Re: plan invalidation vs stored procedures
|
Список | pgsql-hackers |
On Wed, 2008-08-06 at 12:13 +0200, Pavel Stehule wrote: > 2008/8/6 Hannu Krosing <hannu@krosing.net>: > > On Tue, 2008-08-05 at 16:17 +0200, Pavel Stehule wrote: .. > >> you cannot change header of function. It's same as change C header of > >> function without complete recompilation. > > > > SQL is not C. > > > > You don't have to recompile the whole SQL database when you add columns > > to tables, so why should you need to do it, when you add a column to > > table-returning function ? > > > > I thing, it's possible - but it's neccessary completly new dictionary > with dependencies (some dependencies are dynamic - polymorphic > functions) so it's dificult task. I think that you can safely err on the side of caution, that is, save more dependendcies than actually affected. Or you even add dependencies from inside the pl, either at compile/check or run time (cached of course), so that you hit the exact right function oid and can reuse the function lookup already done. ----------------- Hannu
В списке pgsql-hackers по дате отправления: