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

From: Jov <amutu(at)amutu(dot)com>
To: Mehdi Ravanbakhsh <babakco(at)gmail(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: call pl/pgsql function from main pl/pgsql function
Date: 2014-09-28 13:41:14
Message-ID: CADyrUxNj0p_7Anzxkw1mVD2n+hd1skMQqdZV7wEujSk9o7i5+g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.
2014年9月28日 8:25 PM于 "Mehdi Ravanbakhsh" <babakco(at)gmail(dot)com>写道:

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2014-09-28 17:51:55 Re: PANIC: could not create file "pg_xlog/xlogtemp.7884": No space left on device
Previous Message David G Johnston 2014-09-28 13:19:01 Re: call pl/pgsql function from main pl/pgsql function