Re: tip: weird parse error for pl/pgsql - Mailing list pgsql-sql

From Tom Lane
Subject Re: tip: weird parse error for pl/pgsql
Date
Msg-id 6812.966956633@sss.pgh.pa.us
Whole thread Raw
In response to tip: weird parse error for pl/pgsql  (Keith Wong <keith@e-magine.com.au>)
List pgsql-sql
Keith Wong <keith@e-magine.com.au> writes:
> It seems that pl/pgsql has a problem parsing Window style 
> new line characters.

Ah-hah, good catch!  I have fixed this bug for 7.1.  If you want to
patch your local copy, the critical changes are:


*** src/pl/plpgsql/src/scan.l.orig    Thu Jun 22 19:08:34 2000
--- src/pl/plpgsql/src/scan.l    Tue Aug 22 10:59:28 2000
***************
*** 143,155 ****      * Ignore whitespaces but remember this happened      * ----------      */
! [ \t\n]+        { plpgsql_SpaceScanned = 1;        }      /* ----------      * Eat up comments      * ----------
*/
! --[^\n]*        ; \/\*            { start_lineno = yylineno;               BEGIN IN_COMMENT;             }
--- 146,158 ----      * Ignore whitespaces but remember this happened      * ----------      */
! [ \t\r\n]+        { plpgsql_SpaceScanned = 1;        }      /* ----------      * Eat up comments      * ----------
 */
 
! --[^\r\n]*        ; \/\*            { start_lineno = yylineno;               BEGIN IN_COMMENT;             }

        regards, tom lane


pgsql-sql by date:

Previous
From: Mark Volpe
Date:
Subject: Re: Time Help
Next
From: Stephan Szabo
Date:
Subject: Re: Continuous inserts...