Thread: BUG #1099: bad syntax error localisation

The following bug has been logged online:

Bug reference:      1099
Logged by:          Fabien Coelho

Email address:      coelho@cri.ensmp.fr

PostgreSQL version: 7.5 Dev

Operating system:   linux debian

Description:        bad syntax error localisation

Details:

The example is in the regression tests:-)

In src/test/regress/output/create_function_1.source
on line 55:

CREATE FUNCTION test1 (int) RETURNS int LANGUAGE sql
    AS 'not even SQL';
ERROR:  syntax error at or near "not" at character 1

You may notice that word "not" is not at character 1,
where there is "CREATE".

PostgreSQL Bugs List wrote:
> CREATE FUNCTION test1 (int) RETURNS int LANGUAGE sql
>     AS 'not even SQL';
> ERROR:  syntax error at or near "not" at character 1
>
> You may notice that word "not" is not at character 1,
> where there is "CREATE".

The error message refers to the function body, which is parsed
separately and therefore starts the count at 1.

Peter Eisentraut <peter_e@gmx.net> writes:
> PostgreSQL Bugs List wrote:
>> CREATE FUNCTION test1 (int) RETURNS int LANGUAGE sql
>> AS 'not even SQL';
>> ERROR:  syntax error at or near "not" at character 1

> The error message refers to the function body, which is parsed
> separately and therefore starts the count at 1.

I'm surprised there is no CONTEXT line here though.  You would have
gotten one for a syntax error in plpgsql; I must have overlooked doing
it for SQL.

            regards, tom lane