Re: line number in error output

> -----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.