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

From: Peter Geoghegan <peter(dot)geoghegan86(at)gmail(dot)com>
To: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, 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 20:40:52
Message-ID: db471ace1002161240w6d145916ia1952b3ef9c5a5ef@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> We've had several requests for progress reporting thingies of all kinds.
> The amount of effort is not insignificant, which is probably why nothing
> has gotten done yet ...

What do you mean by "reporting thingies of all kinds"? It isn't as if
I'm asking for some esoteric feature, some regional variation of
reporting on batch operations. I'd like to be able to report things
back to client apps. That would perhaps take the form of returning a
message string, and an integer at each RETURN NEXT (or whatever
mechanism is decided upon). It would probably still be very useful to
a lot of people if the feature was completely inflexible, not allowing
you to vary the RETURN NEXT datatype, for example.

Can't someone think of a way of doing this as a neat adjunct to Postgres?

Thanks,
Peter Geoghegan

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David Kerr 2010-02-16 20:57:28 ERROR: permission denied to finish prepared transaction
Previous Message Andreas Kretschmer 2010-02-16 19:21:20 Re: Postgres physical directory structure meaning