From: | ashima athri <ashimaathri(at)gmail(dot)com> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org, leon_starr(at)modelint(dot)com |
Subject: | Fwd: How to 'print a table' in the middle of a plpgsql function |
Date: | 2011-01-30 03:55:42 |
Message-ID: | AANLkTik6a9_+urhkrF7xP4Xq1rSFck5LBB+4Pu2WWWT1@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
On Sun, Jan 30, 2011 at 1:19 AM, Mladen Gogala <mladen(dot)gogala(at)vmsinfo(dot)com>wrote:
> On 1/29/2011 12:59 AM, Leon Starr wrote:
>
>> 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.
>>
> Raise notice is PLPGSQL equivalent of DBMS_OUTPUT.PUT_LINE.
>
> --
> 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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-novice
>
From | Date | Subject | |
---|---|---|---|
Next Message | Leon Starr | 2011-01-30 18:10:55 | Re: How to 'print a table' in the middle of a plpgsql function |
Previous Message | Mladen Gogala | 2011-01-29 19:49:57 | Re: How to 'print a table' in the middle of a plpgsql function |