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

On Mon, Jul 18, 2011 at 02:05:42PM -0400, Alvaro Herrera wrote:
> 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.

That solves the non-customized part of the problem, which is worth
solving.  A complete parser for a given DB would need catalog access,
i.e. a live connection to that DB.

Cheers,
David.
-- 
David Fetter <david@fetter.org> http://fetter.org/
Phone: +1 415 235 3778  AIM: dfetter666  Yahoo!: dfetter
Skype: davidfetter      XMPP: david.fetter@gmail.com
iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate