From: | David G Johnston <david(dot)g(dot)johnston(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: call pl/pgsql function from main pl/pgsql function |
Date: | 2014-09-28 13:19:01 |
Message-ID: | 1411910341931-5820820.post@n5.nabble.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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.
From | Date | Subject | |
---|---|---|---|
Next Message | Jov | 2014-09-28 13:41:14 | Re: call pl/pgsql function from main pl/pgsql function |
Previous Message | Roopeshakumar Narayansa Shalgar (rshalgar) | 2014-09-28 12:52:11 | Re: PANIC: could not create file "pg_xlog/xlogtemp.7884": No space left on device |