Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 083871337BF7 for ; Tue, 3 May 2011 19:51:53 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 91652-01-8 for ; Tue, 3 May 2011 22:51:34 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-vx0-f174.google.com (mail-vx0-f174.google.com [209.85.220.174]) by mail.postgresql.org (Postfix) with ESMTP id 958AC1338088 for ; Tue, 3 May 2011 19:27:52 -0300 (ADT) Received: by vxi39 with SMTP id 39so495422vxi.19 for ; Tue, 03 May 2011 15:27:52 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:date:message-id:subject:from:to :content-type; bh=GkI/b/MeG0UfBeF2fqtT7Gt83yvJO/I1z4PT2JKjWck=; b=MBkb6tO5CJoqE2KRQZx2ehl5wjVJLNJO4oUhSbBo72PjPeq92BxeYS0w29I/PlmqnE W9a7omwXoWCzYCBeSPsOvRKTdwJQ3fELvp9lHUjgZTvNGcQybFn2u/O8oceY0erwJ662 rCBwLEFsDWW5A3Kt6orTiKYWkbuJ6QtUZBRJc= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:date:message-id:subject:from:to:content-type; b=DAvejnwr8G5AqCYtBqFiHNgGNNhwXpwQoIUZrsnUBPYnmPGcAlliI+uwQSI7ks/nK6 6q+wTUv+kZQ8m+NIlcM0DcJqVU+34f4zIiKOWxyzU4VjmkYolS/PNw/Jhw5eQPbVlJro NMv0yOK+ix7T6LRdBDOh8BPwncHLkOKDNGAPI= MIME-Version: 1.0 Received: by 10.220.110.197 with SMTP id o5mr91502vcp.248.1304461672523; Tue, 03 May 2011 15:27:52 -0700 (PDT) Received: by 10.220.202.71 with HTTP; Tue, 3 May 2011 15:27:52 -0700 (PDT) Date: Wed, 4 May 2011 00:27:52 +0200 Message-ID: Subject: function timeout From: =?UTF-8?Q?Viktor_Bojovi=C4=87?= To: pgsql-sql@postgresql.org Content-Type: multipart/alternative; boundary=001485e76f5a9d26f804a266a605 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.887 tagged_above=-5 required=5 tests=BAYES_00=-1.9, FREEMAIL_FROM=0.001, HTML_MESSAGE=0.001, RFC_ABUSE_POST=0.001, T_TO_NO_BRKTS_FREEMAIL=0.01 X-Spam-Level: X-Archive-Number: 201105/19 X-Sequence-Number: 35303 --001485e76f5a9d26f804a266a605 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable im writting plsh function which will execute some shell commands and return result as varchar to database. problem is that some commands will possibly cause to large timeout or will never stop so i wanted to ask if somehow function can be autokilled if it doesn't finish in time defined for that function. --=20 --------------------------------------- Viktor Bojovi=C4=87 --------------------------------------- Wherever I go, Murphy goes with me --001485e76f5a9d26f804a266a605 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
im writting plsh function which will execute some shell commands and r= eturn =C2=A0result as varchar to database.
prob= lem is that some commands will possibly cause to large timeout or will neve= r stop so i wanted to ask =C2=A0
if somehow function can be autokilled if it doesn't finish in time= defined for that function.


--
----------------= -----------------------
Viktor Bojovi=C4=87
-------------------------= --------------
Wherever I go, Murphy goes with me
--001485e76f5a9d26f804a266a605--