Re: line number in error output

From: Miha Radej <miha(dot)radej(at)siix(dot)com>
To: Dave Page <dpage(at)vale-housing(dot)co(dot)uk>
Cc: pgadmin-support(at)postgresql(dot)org
Subject: Re: line number in error output
Date: 2006-04-05 10:20:24
Message-ID: 443399E8.5010508@siix.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Hi!

Dave Page wrote:
>> 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.

How does that work with localized server messages, how does pgAdmin
handle them? I get a partly translated error message from the server:

NAPAKA: napaka v sintaksi at or near "form" pri znaku 11

pgAdmin does not put any markers in the left margin here.

Regards,
Miha

In response to

Browse pgadmin-support by date

  From Date Subject
Next Message Miha Radej 2006-04-05 16:44:58 Re: [pgadmin-support] Feature request - option to exclude docs when
Previous Message Chris Velevitch 2006-04-05 09:47:37 rename database