Re: proposal: new contrib module plpgsql's embeded sql validator

Excerpts from Jim Nasby's message of dom jul 17 16:31:45 -0400 2011:

> On a somewhat related note, I'd also really like to have the ability to parse things like .sql files externally, to do things like LINT checking.

We talked about this during PGCon. The idea that seemed to have
consensues there was to export the parser similarly to how we build the
ecpg parser, that is, a set of perl scripts which take our gram.y as
input and modify it to emit something different. What ecpg does with it
is emit a different grammar, but it doesn't seem impossible to me to
have it emit some sort of (lint) checker.

I admit I haven't looked at the new Perl scripts we use in ecpg (they
were rewritten in the 9.1 era).

--
Álvaro Herrera <alvherre(at)commandprompt(dot)com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support