Re: Tracking progress of (plpgsql?) operations - Mailing list pgsql-novice

From Bruno Wolff III
Subject Re: Tracking progress of (plpgsql?) operations
Date
Msg-id 20060503134409.GB29954@wolff.to
Whole thread Raw
In response to Tracking progress of (plpgsql?) operations  (k992637@yahoo.com)
Responses Re: Tracking progress of (plpgsql?) operations
List pgsql-novice
On Sun, Apr 30, 2006 at 16:36:04 -0700,
  k992637@yahoo.com wrote:
> as I can tell) see the intermediate stage of processing.  What I would
> ideally like is to be able to update a log table which stored how many
> values of A were selected and how many values of A have finished
> calculating, updating this every 5 iterations or so.  However I will
> never see an intermediate state in this table due to transactions (is
> this correct?).

If you use a trusted PL language, you can write to files which will probably
allow you to do what you want.

pgsql-novice by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: Forgotten Password
Next
From: Sean Davis
Date:
Subject: Re: Snapshot Copy of a Postgres DB