Re: call pl/pgsql function from main pl/pgsql function - Mailing list pgsql-general

From David G Johnston
Subject Re: call pl/pgsql function from main pl/pgsql function
Date
Msg-id 1411910341931-5820820.post@n5.nabble.com
Whole thread Raw
In response to call pl/pgsql function from main pl/pgsql function  (Mehdi Ravanbakhsh <babakco@gmail.com>)
List pgsql-general
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.


pgsql-general by date:

Previous
From: Mehdi Ravanbakhsh
Date:
Subject: call pl/pgsql function from main pl/pgsql function
Next
From: "Roopeshakumar Narayansa Shalgar (rshalgar)"
Date:
Subject: Re: PANIC: could not create file "pg_xlog/xlogtemp.7884": No space left on device