Re: line number in error output - Mailing list pgadmin-support

From Dave Page
Subject Re: line number in error output
Date
Msg-id E7F85A1B5FF8D44C8A1AF6885BC9A0E4011C9A31@ratbert.vale-housing.co.uk
Whole thread Raw
In response to line number in error output  ("Chris Velevitch" <chris.velevitch@gmail.com>)
Responses Re: line number in error output
List pgadmin-support

> -----Original Message-----
> From: pgadmin-support-owner@postgresql.org
> [mailto:pgadmin-support-owner@postgresql.org] On Behalf Of
> Chris Velevitch
> Sent: 05 April 2006 08:17
> To: pgadmin-support@postgresql.org
> Subject: [pgadmin-support] line number in error output
>
> I'm using Windows version 1.4.2 on Win XP sp1.
>
> When I get an error in executing a sql code, I get
>
>      ERROR:  syntax error at or near "45183" at character 5848
>
> There is no line number included. Such information would make
> very easy to locate the offending code.

The error messages comes from PostgreSQL so we cannot change it. pgAdmin
looks at the character number though and bungs a marker in the left
margin to highlight the offending line in your code.

Regards, Dave.


pgadmin-support by date:

Previous
From: "Chris Velevitch"
Date:
Subject: line number in error output
Next
From: Mauro Bertoli
Date:
Subject: UI Request