Postgres Pro
Downloads
Home   >   mailing lists

Re: Having a plpgsql function return multiple rows that indicate its progress in a cursor like fashion - Mailing list pgsql-general

From Tom Lane
Subject Re: Having a plpgsql function return multiple rows that indicate its progress in a cursor like fashion
Date
Msg-id 18602.1266361090@sss.pgh.pa.us
Whole thread Raw
In response to Re: Having a plpgsql function return multiple rows that indicate its progress in a cursor like fashion  (Peter Geoghegan <peter.geoghegan86@gmail.com>)
Responses Re: Having a plpgsql function return multiple rows that indicate its progress in a cursor like fashion  (Peter Geoghegan <peter.geoghegan86@gmail.com>)
Re: Having a plpgsql function return multiple rows that indicate its progress in a cursor like fashion  (Dimitri Fontaine <dfontaine@hi-media.com>)
List pgsql-general
Tree view 
Peter Geoghegan <peter.geoghegan86@gmail.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

pgsql-general by date:

Previous
From: Peter Geoghegan
Date:
Subject: Re: Having a plpgsql function return multiple rows that indicate its progress in a cursor like fashion
Next
From: Peter Geoghegan
Date:
Subject: Re: Having a plpgsql function return multiple rows that indicate its progress in a cursor like fashion