are there any way to make them global for all the instances? On 10/14/2005, "Douglas McNaught" <doug@xxxxxxxxxxxx> wrote: >TJ O'Donnell <tjo@xxxxxxx> writes: > >> I have begun to use some static variables in my c-language >> functions to maintain state (3rd party licensing issues) during >> the course of a session (postgres process, spawned by postmaster). >> These are declared static outside the scope of any function. >> (is global the correct term anymore?) >> When I use dynamic loading of my .so, >> each session is independent, with its own static variables. >> Will the same be true if I were to load the .so once when >> the database starts up? Or will there be just one set of >> static variables for all sessions? > >Each backend process has its own memory space, so the variables will >still be independent. > >-Doug > >---------------------------(end of broadcast)--------------------------- >TIP 2: Don't 'kill -9' the postmaster ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match