Re: Having a plpgsql function return multiple rows that indicate its progress in a cursor like fashion

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Peter Geoghegan <peter(dot)geoghegan86(at)gmail(dot)com>
Cc: Alban Hertroys <dalroi(at)solfertje(dot)student(dot)utwente(dot)nl>, PGSQL Mailing List <pgsql-general(at)postgresql(dot)org>
Subject: Re: Having a plpgsql function return multiple rows that indicate its progress in a cursor like fashion
Date: 2010-02-16 22:58:10
Message-ID: 18602.1266361090@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Peter Geoghegan <peter(dot)geoghegan86(at)gmail(dot)com> writes:
> Aren't my requirements sufficiently common to justify developing a
> mechanism to report progress back to client applications during batch
> operations and the like?

Have you experimented with RAISE NOTICE? Using it this way is a bit of
a hack maybe, but I think you are entirely unaware of what would be
involved in producing something that's less of a hack.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Justin Pasher 2010-02-16 23:13:22 Source RPMs for PostgreSQL 7.4.27 on RHEL4
Previous Message Peter Geoghegan 2010-02-16 22:34:14 Re: Having a plpgsql function return multiple rows that indicate its progress in a cursor like fashion