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

From Peter Geoghegan
Subject Re: Having a plpgsql function return multiple rows that indicate its progress in a cursor like fashion
Date
Msg-id db471ace1002161539i4d0f55edn94c6f1db21780197@mail.gmail.com
Whole thread Raw
In response to Re: Having a plpgsql function return multiple rows that indicate its progress in a cursor like fashion  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
>> 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.

That assessment is accurate. Should I take it that you aren't
particularly interested in pursuing something like this at present?

I'll see what I can come up with by playing with RAISE NOTICE

Thanks,
Peter Geoghegan

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Having a plpgsql function return multiple rows that indicate its progress in a cursor like fashion
Next
From: Justin Pasher
Date:
Subject: Source RPMs for PostgreSQL 7.4.27 on RHEL4