> -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] 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. ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly