Re: Ok, how do I debug THIS?

Josh Berkus <josh(at)agliodbs(dot)com> writes:
>> I just did a head. Note the line count above. It's only 147
>> lines, but the error refers to line 206.

> Obviously postgres is counting lines differently from you.

Just FYI, I noticed the other day while testing some plpgsql changes
that the 7.3 plpgsql seems to double-count newlines appearing inside
quoted literals --- that is, if you have a syntax error appearing after
a multiline literal, the reported line number will be too large. This
seems to explain Larry's bizarre message, since most of the function
was being taken as a multiline literal.

The reason I noticed this was that the updated version counts correctly,
and thus gave different answers. I don't know exactly where the bug
really was --- the changes involved ripping out the use of yylineno
entirely, so I did not look to see just where the double counting had
been happening.

regards, tom lane