Re: BUG #5867: wish: plpgsql print table for debug - Mailing list pgsql-bugs

From Robert Haas
Subject Re: BUG #5867: wish: plpgsql print table for debug
Date
Msg-id AANLkTinU5FwUNoGWtybEghbTw7_HH0msWrfeOfVtmsK+@mail.gmail.com
Whole thread Raw
In response to Re: BUG #5867: wish: plpgsql print table for debug  (Richard Neill <rn214@richardneill.org>)
Responses Re: BUG #5867: wish: plpgsql print table for debug
Re: BUG #5867: wish: plpgsql print table for debug
List pgsql-bugs
On Thu, Mar 3, 2011 at 12:12 PM, Richard Neill <rn214@richardneill.org> 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 stretching the analogy a bit here, but it seems to me that
> a multi-row table is to postgresql as int is to C.]

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.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #5906: assertion failure in AtCleanup_Portals
Next
From: David Schmitt
Date:
Subject: Re: BUG #5869: postgresql corrupts unquoted non-ascii chars in column aliases