Re: a few small bugs in plpgsql - Mailing list pgsql-hackers

From Pavel Stehule
Subject Re: a few small bugs in plpgsql
Date
Msg-id AANLkTi=cz6xnkH2-QmGMWOxZor4W-nmcNds+UvMXfZbC@mail.gmail.com
Whole thread Raw
In response to Re: a few small bugs in plpgsql  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: proposal: plpgsql, solution for derivated types of parameters
Next
From: Fujii Masao
Date:
Subject: Re: Issues with Quorum Commit