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 r...@iol.ie -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
