Re: [BUGS] BUG #5867: wish: plpgsql print table for debug

2011-03-03 Thread Pavel Stehule
2011/3/3 Dimitri Fontaine : > Tom Lane writes: >> Note that doing anything more than RAISE NOTICE or equivalent would >> imply a significant protocol change. > > My understanding is that the standard allows multiple resultsets per > query, is that the protocol change you're talking about? > There

Re: [BUGS] BUG #5867: wish: plpgsql print table for debug

2011-03-03 Thread Dimitri Fontaine
Tom Lane writes: > Note that doing anything more than RAISE NOTICE or equivalent would > imply a significant protocol change. My understanding is that the standard allows multiple resultsets per query, is that the protocol change you're talking about? Regards, -- Dimitri Fontaine http://2ndQuad

Re: [BUGS] BUG #5867: wish: plpgsql print table for debug

2011-03-03 Thread Merlin Moncure
On Thu, Mar 3, 2011 at 12:37 PM, Richard Neill wrote: > >> Sure it does.  You can pass the tuple to RAISE NOTICE easily enough. >> It won't have all the same bells and whistles psql would supply, but >> it prints out well enough for debugging.  Or at least it's never >> bothered me. > > Sorry if I

Re: [BUGS] BUG #5867: wish: plpgsql print table for debug

2011-03-03 Thread Pavel Stehule
2011/3/3 Richard Neill : > >> Sure it does.  You can pass the tuple to RAISE NOTICE easily enough. >> It won't have all the same bells and whistles psql would supply, but >> it prints out well enough for debugging.  Or at least it's never >> bothered me. > > Sorry if I'm being dense, but I can't se

Re: [BUGS] BUG #5867: wish: plpgsql print table for debug

2011-03-03 Thread Richard Neill
Note that doing anything more than RAISE NOTICE or equivalent would imply a significant protocol change. You can't just shove a table out to the client, because it'll think that that's the response to the outer SELECT (or whatever) command that called your function. So while it'd be kind of co

Re: [BUGS] BUG #5867: wish: plpgsql print table for debug

2011-03-03 Thread Richard Neill
Sure it does. You can pass the tuple to RAISE NOTICE easily enough. It won't have all the same bells and whistles psql would supply, but it prints out well enough for debugging. Or at least it's never bothered me. Sorry if I'm being dense, but I can't see how you can pass a tuple; I think r

Re: [BUGS] BUG #5867: wish: plpgsql print table for debug

2011-03-03 Thread Richard Neill
Dear Pavel, Thanks for your help. Do you not think it would be really amazingly useful? After all, in C, the single most useful debugging tool is "fprintf(stderr,...)", and yet postgresql doesn't have an equivalent that can operate on the most common data format. [I'm stretching the analogy a b

Re: [BUGS] BUG #5867: wish: plpgsql print table for debug

2011-03-03 Thread Robert Haas
On Thu, Mar 3, 2011 at 1:37 PM, Richard Neill wrote: > >> Sure it does.  You can pass the tuple to RAISE NOTICE easily enough. >> It won't have all the same bells and whistles psql would supply, but >> it prints out well enough for debugging.  Or at least it's never >> bothered me. > > Sorry if I'

Re: [BUGS] BUG #5867: wish: plpgsql print table for debug

2011-03-03 Thread Tom Lane
Robert Haas writes: > On Thu, Mar 3, 2011 at 12:12 PM, Richard Neill wrote: >> Do you not think it would be really amazingly useful? After all, in C, the >> single most useful debugging tool is "fprintf(stderr,...)", and yet >> postgresql doesn't have an equivalent that can operate on the most co

Re: [BUGS] BUG #5867: wish: plpgsql print table for debug

2011-03-03 Thread Robert Haas
On Thu, Mar 3, 2011 at 12:12 PM, Richard Neill wrote: > Do you not think it would be really amazingly useful? After all, in C, the > single most useful debugging tool is "fprintf(stderr,...)", and yet > postgresql doesn't have an equivalent that can operate on the most common > data format. [I'm s

Re: [BUGS] BUG #5867: wish: plpgsql print table for debug

2011-03-03 Thread Pavel Stehule
Hello > > Do you not think it would be really amazingly useful? After all, in C, the > single most useful debugging tool is "fprintf(stderr,...)", and yet > postgresql doesn't have an equivalent that can operate on the most common > data format. [I'm stretching the analogy a bit here, but it seems

Re: [BUGS] BUG #5867: wish: plpgsql print table for debug

2011-03-03 Thread Richard Neill
The following bug has been logged online: Bug reference: 5867 Logged by: Richard Neill Email address: postgre...@richardneill.org PostgreSQL version: 9.03 Operating system: Linux Description:wish: plpgsql print table for debug Details: When debugging a plpgsql functi

Re: [BUGS] BUG #5867: wish: plpgsql print table for debug

2011-03-03 Thread Robert Haas
On Mon, Feb 7, 2011 at 1:01 AM, Richard Neill wrote: > > The following bug has been logged online: > > Bug reference:      5867 > Logged by:          Richard Neill > Email address:      postgre...@richardneill.org > PostgreSQL version: 9.03 > Operating system:   Linux > Description:        wish: p

[BUGS] BUG #5867: wish: plpgsql print table for debug

2011-02-06 Thread Richard Neill
The following bug has been logged online: Bug reference: 5867 Logged by: Richard Neill Email address: postgre...@richardneill.org PostgreSQL version: 9.03 Operating system: Linux Description:wish: plpgsql print table for debug Details: When debugging a plpgsql funct