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?