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

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.

In response to

Browse pgsql-general by date

  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