Re: tip: weird parse error for pl/pgsql

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