David G Johnston wrote > On Fri, Sep 29, 2017 at 6:46 AM, athinivas <
> athinivas@
> > wrote: > >> Hi, >> >> Is it possible to have static variable inside pgSQL C functions (or) >> PL/pgSQL?? I'm having a use case where I need to update a counter inside >> the >> function & it should be thread-safe. >> >> I've tried using static variable inside the C function along with >> pthread_mutex_lock/pthread_mutex_unlock. And found functions are not >> shared >> among each other. >> >> > Don't know what's possible in C; pretty sure no in pl/pgsql. > > Why not just use a table and SQL locking features? > > Dave
Sadly, I'm doing it in slave server, so not able to use any table INSERT/UPDATE. Does current_Setting() can be used to access any global variables??