Re: line number in error output

["Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>]

> -----Original Message-----
> From: pgadmin-support-owner(at)postgresql(dot)org 
> [mailto:pgadmin-support-owner(at)postgresql(dot)org] On Behalf Of 
> Chris Velevitch
> Sent: 05 April 2006 08:17
> To: pgadmin-support(at)postgresql(dot)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.