> Another thing I do not understand well is how people are expected to work in > 8.3 with a function based API, without hitting Skype problems. People are expected to use same workarounds as Skype is using. For us another unneccessary downtime week ago was what set us moving/thinking :). When you use software with limitations then you learn to live with them. Good thing about postgres you can do something yourself to get some of the limitations removed. As Pavel said you are probably using your own build anyway so one more patch should not be a problem.
> Le mardi 19 août 2008, Tom Lane a écrit : >> [ shrug... ] You have not found a bug in plan invalidation. You have >> found omitted functionality --- functionality that was *intentionally* >> omitted from the 8.3 version. > > Thanks a lot for this clarification, now I understand you viewpoint. > > So, the 8.3 "fix" would be about documenting this intentionnal omit in the > great manual, maybe in a Limits section of the sql-createfunction page? > > Another thing I do not understand well is how people are expected to work in > 8.3 with a function based API, without hitting Skype problems. I'm having a > project here where the project manager wants a database function API to keep > data logic at serverside, should I tell him to reconsider this while 8.4 is > not ready?
You could to use patched 8.3.
> We would then have to go live with an 8.3 based solution containing middleware > code, then port it again to SQL functions when 8.4 is out & stable. Not > appealing, but I sure understand the no new feature in stable code base > argument here.
This problem isn't too hard without pooling. Not all systems are global - so usually is possible to find some window and recreate functions and close all user connections.