From: | "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk> |
---|---|
To: | "Chris Velevitch" <chris(dot)velevitch(at)gmail(dot)com>, <pgadmin-support(at)postgresql(dot)org> |
Subject: | Re: line number in error output |
Date: | 2006-04-05 08:17:49 |
Message-ID: | E7F85A1B5FF8D44C8A1AF6885BC9A0E4011C9A31@ratbert.vale-housing.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
> -----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.
From | Date | Subject | |
---|---|---|---|
Next Message | Mauro Bertoli | 2006-04-05 08:33:57 | UI Request |
Previous Message | Chris Velevitch | 2006-04-05 07:59:55 | Re: silently fails to connect to remote server |