In PostgreSQL 9.1, the line numbering of PL/pgSQL functions was changed
by this commit:
> commit c3a05881de21438a29b6dc721ebd7d1e028a905a
> Author: Robert Haas <rhaas(at)postgresql(dot)org>
> Date: Mon Aug 2 03:46:54 2010 +0000
> Remove ancient PL/pgsql line numbering hack.
> While this hack arguably has some benefit in terms of making PL/pgsql's
> line numbering match the programmer's expectations, it also makes
> PL/pgsql inconsistent with the remaining PLs, making it difficult for
> clients to reliably determine where the error actually is. On balance,
> it seems better to be consistent.
> Pavel Stehule
The hack that was removed skipped an initial newline when counting line
numbers. The PL/pgSQL debugger has a similar hack, but it didn't get the
memo that it was removed in the backend, so the green current line
marker is off by one when connected to a 9.1 server. Attached is a patch
to fix that.
pgadmin-hackers by date
|Next:||From: Dave Page||Date: 2012-04-25 11:22:34|
|Subject: Re: Debugger line numbering is off by one|
|Previous:||From: Thom Brown||Date: 2012-04-25 07:27:12|
|Subject: Re: Incorrect domain logic for 9.1|