function timeout

From: Viktor Bojović <viktor(dot)bojovic(at)gmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: function timeout
Date: 2011-05-03 22:27:52
Message-ID: BANLkTinpwZY47PnhJyO2iwEB1RPGwTjMdQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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.

--
---------------------------------------
Viktor Bojović
---------------------------------------
Wherever I go, Murphy goes with me

Browse pgsql-sql by date

  From Date Subject
Next Message Andreas Kretschmer 2011-05-04 05:28:36 Re: How to realize ROW_NUMBER() in 8.3?
Previous Message Steve Crawford 2011-05-03 15:54:29 Re: convert in GMT time zone without summer time