Re: BUG #5867: wish: plpgsql print table for debug

Поиск
Список
Период
Сортировка
Искать
От
Pavel Stehule
Тема
Re: BUG #5867: wish: plpgsql print table for debug
Дата
Msg-id
AANLkTimOtW2p3kaUpSeF8vH7wOLORHv2akj1W_kiAfSg@mail.gmail.com
Ответ на
Список
Дерево обсуждения
BUG #5867: wish: plpgsql print table for debug "Richard Neill" <postgresql@richardneill.org>
Re: BUG #5867: wish: plpgsql print table for debug Robert Haas <robertmhaas@gmail.com>
Re: BUG #5867: wish: plpgsql print table for debug Richard Neill <rn214@richardneill.org>
Re: BUG #5867: wish: plpgsql print table for debug Pavel Stehule <pavel.stehule@gmail.com>
Re: BUG #5867: wish: plpgsql print table for debug Richard Neill <rjn@richardneill.org>
Re: BUG #5867: wish: plpgsql print table for debug Robert Haas <robertmhaas@gmail.com>
Re: BUG #5867: wish: plpgsql print table for debug Tom Lane <tgl@sss.pgh.pa.us>
Re: BUG #5867: wish: plpgsql print table for debug Richard Neill <rjn@richardneill.org>
Re: BUG #5867: wish: plpgsql print table for debug Dimitri Fontaine <dimitri@2ndQuadrant.fr>
Re: BUG #5867: wish: plpgsql print table for debug Pavel Stehule <pavel.stehule@gmail.com>
Re: BUG #5867: wish: plpgsql print table for debug Richard Neill <rjn@richardneill.org>
Re: BUG #5867: wish: plpgsql print table for debug Merlin Moncure <mmoncure@gmail.com>
Re: BUG #5867: wish: plpgsql print table for debug Robert Haas <robertmhaas@gmail.com>
Re: BUG #5867: wish: plpgsql print table for debug Pavel Stehule <pavel.stehule@gmail.com>
2011/3/3 Richard Neill :
>
>> Sure it does. =C2=A0You 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. =C2=A0Or 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 thi=
nk
> raise-notice only lets you pass individual strings/integers. But I don't
> think we can pass all of them without specifying in advance how many there
> are....

yes, it's possible for ROW or RECORD datatype

Regards

Pavel Stehule

>
>
>
> --
> Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-bugs
>
В списке pgsql-bugs по дате отправления
От: Richard Neill
Дата:
От: Merlin Moncure
Дата:
FAQ