Thread: Display line numbers in query tool

Display line numbers in query tool

From
"Danny Lo"
Date:
<div class="Section1"><p class="MsoNormal">Hi, I’m a novice SQL user running pgadmin version v 1.10.1 and I’m wondering
ifthe query tool can support displaying line numbers for the purpose of debugging moderate sized plpgsql scripts. <p
class="MsoNormal"> <pclass="MsoNormal">Thanks very much,<p class="MsoNormal"> <p class="MsoNormal">Regards,<br /> Danny
<pclass="MsoNormal"> </div> 

Re: Display line numbers in query tool

From
Raymond O'Donnell
Date:
On 12/02/2010 00:39, Danny Lo wrote:
> Hi, I'm a novice SQL user running pgadmin version v 1.10.1 and I'm wondering
> if the query tool can support displaying line numbers for the purpose of
> debugging moderate sized plpgsql scripts. 

Actually, the edit window does give you the current line and column in
the status bar, which is good enough for most purposes.

An additional complication AFAICT is that the line number in error
messages returned from PostgreSQL isn't necessarily (or even usually)
the line number as you see it in the edit window - I suppose that for PG
line numbering starts from the body of the function, leaving out the
"create or replace function..." command.

However, I agree that line numbers in the left column would be a nice
touch... +1 for its inclusion.

Ray.

-- 
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie