Fwd: How to 'print a table' in the middle of a plpgsql function
| От | ashima athri |
|---|---|
| Тема | Fwd: How to 'print a table' in the middle of a plpgsql function |
| Дата | |
| Msg-id | AANLkTik6a9_+urhkrF7xP4Xq1rSFck5LBB+4Pu2WWWT1@mail.gmail.com обсуждение исходный текст |
| Ответ на | How to 'print a table' in the middle of a plpgsql function (Leon Starr <leon_starr@modelint.com>) |
| Ответы |
Re: How to 'print a table' in the middle of a plpgsql function
Re: How to 'print a table' in the middle of a plpgsql function |
| Список | pgsql-novice |
You can use RAISE INFO instead (it doesn't print the stack)
http://www.postgresql.org/docs/7.4/static/plpgsql-errors-and-messages.html
There is also a pgAdmin Debugger
http://www.pgadmin.org/docs/1.8/debugger.html
There is also a pgAdmin Debugger
http://www.pgadmin.org/docs/1.8/debugger.html
On Sun, Jan 30, 2011 at 1:19 AM, Mladen Gogala <mladen.gogala@vmsinfo.com> wrote:
On 1/29/2011 12:59 AM, Leon Starr wrote:Raise notice is PLPGSQL equivalent of DBMS_OUTPUT.PUT_LINE.I am deep into debugging some pretty extensive plpgsql and it would be nice sometimes if I could somehow output the content of a table to the psql console at a particular point in a function.
For example, I am executing a select that is not returning the expected row. So I am wondering, what exactly was in the table at the time the query was performed.
Of course, I could just write a loop prior to my query with a bunch of raise notice statements, but I'll get a stack trace for each one. So that won't be pretty.
Suggestions? Thx.
--
Mladen Gogala
Sr. Oracle DBA
1500 Broadway
New York, NY 10036
(212) 329-5251
www.vmsinfo.com
--
Sent via pgsql-novice mailing list (pgsql-novice@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-novice
В списке pgsql-novice по дате отправления: