Re: Static variable inside PL/pgSQL (or) native C function

Hi

2017-09-29 15:46 GMT+02:00 athinivas <athinivas(at)gmail(dot)com>:

> 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.
>

no, there are no similar feature. More it should not work as you are
expecting, because PostgreSQL is process based, not thread based.

For this purpose, you can write some simple extension designed over shared
memory.

Regards

Pavel

>
> Thanks,
> Athi
>
>
>
> --
> Sent from: http://www.postgresql-archive.org/PostgreSQL-sql-f2142323.html
>
>
> --
> Sent via pgsql-sql mailing list (pgsql-sql(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-sql
>