Re: proposal: new contrib module plpgsql's embeded sql validator - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: proposal: new contrib module plpgsql's embeded sql validator
Date
Msg-id 1311012052-sup-1482@alvh.no-ip.org
Whole thread Raw
In response to Re: proposal: new contrib module plpgsql's embeded sql validator  (Jim Nasby <jim@nasby.net>)
Responses Re: proposal: new contrib module plpgsql's embeded sql validator
List pgsql-hackers
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
dothings 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@commandprompt.com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support


pgsql-hackers by date:

Previous
From: Alexander Korotkov
Date:
Subject: Re: WIP: Fast GiST index build
Next
From: Pavel Stehule
Date:
Subject: Re: patch for 9.2: enhanced errors