Re: BUG #1099: bad syntax error localisation - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #1099: bad syntax error localisation
Date
Msg-id 20207.1079020628@sss.pgh.pa.us
Whole thread Raw
In response to Re: BUG #1099: bad syntax error localisation  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-bugs
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

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #1098: Multiple ON INSERT rules not applied properly in the case of INSERT...SELECT
Next
From: Joe Conway
Date:
Subject: Re: Glitch: cannot use Arrays with Raise Notice