Thread: call pl/pgsql function from main pl/pgsql function

Mehdi Ravanbakhsh wrote
> Hi All
>
> I have one main function in  pl/pgsql and one subset function in pl/pgsql
> .
>
> i need to call  Subset Function From main function and i do not need to
> wait for subset Function return. I just need to send parameter to subset
> function and do not need any thing in return.
>
> So i can call multiply subset function  repeatedly.
>
> Any one can help with this problem ?

All functions are synchronous.  Best you can do is write the sub function to
return quickly by, for instance, having it simply write to a table and have
a task processor handle the work in a separate session.

David J.




--
View this message in context:
http://postgresql.1045698.n5.nabble.com/call-pl-pgsql-function-from-main-pl-pgsql-function-tp5820818p5820820.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

Plain pg function is synchronization,the main function must wait for the sub function over.
I rember dblink can send asynchronous query,maybe you can wrap your sub function with dblink.but transition behavior should be careful thought.