pl/perl setof function

From: Alex - <aintokyo(at)hotmail(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: pl/perl setof function
Date: 2010-01-13 18:20:55
Message-ID: SNT135-w572288B3D2FD3FF79FBD84CF6B0@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Hi,i have a PL/PERL RETURN SETOF function which processes a few 10k records.The processing takes quite some time and in order to display progressI use a return_next after every few thousand records.
However, the function returns all messages when it completes and exists which is not really what i want. I also tried the elog NOTICE but then I only get the messages back to the psql.
I am calling the function from a perl script and would like to catch these progress messages.
Is there any way to solve my problem?
ThanksAlex
_________________________________________________________________
Search for properties that match your lifestyle! Start searching NOW!
http://clk.atdmt.com/NMN/go/157631292/direct/01/

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andrej 2010-01-13 18:52:14 Re: log_temp_files confusion
Previous Message Daniel Schuchardt 2010-01-13 18:01:24 Re: postgresql 8.1 windows 2008 64 bit