Re: a few small bugs in plpgsql

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: a few small bugs in plpgsql
Дата
Msg-id AANLkTi=cz6xnkH2-QmGMWOxZor4W-nmcNds+UvMXfZbC@mail.gmail.com
обсуждение исходный текст
Ответ на Re: a few small bugs in plpgsql  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
2010/10/8 Tom Lane <tgl@sss.pgh.pa.us>:
> Pavel Stehule <pavel.stehule@gmail.com> writes:
>> Now I understand to interpretation. But there is little bit difficult
>> to understand to error message. Can be message enhanced to show a
>> complete expression?
>
> It does already:
>
> regression=# select foo();
> ERROR:  column "label" does not exist
> LINE 2:   <<label>>
>            ^
> QUERY:  SELECT 10

the keyword QUERY is misleading :(

but you have a true - there are all necessary information.

Regards

Pavel Stehule


>  <<label>>
> CONTEXT:  PL/pgSQL function "foo" line 3 at FOR with integer loop variable
>
> The "query" is SELECT followed by whatever plpgsql thought the
> expression was.
>
>                        regards, tom lane
>


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Pavel Stehule
Дата:
Сообщение: Re: proposal: plpgsql, solution for derivated types of parameters
Следующее
От: Fujii Masao
Дата:
Сообщение: Re: Issues with Quorum Commit