[pgpool-hackers: 3007] Import PostgreSQL11 parser

[Bo Peng]

Hi all,

The attached patch imports PostgreSQL11 beta3 parser to Pgpool-II 4.0.

Major chanegs of PostgreSQL11 parser include:

- Add new commands by addind a new object type "procedure".

   -- CALL
   -- CREATE/ALTER/DROP PROCEDURE
   -- ALTER/DROP ROUTINE


- Add new commands added by the improvement of partitioning.

   -- CREATE INDEX ON ONLY <table>
                      ~~~~
   -- ALTER INDEX ATTACH PARTITION


- Add INCLUDE clause in index definition.

   -- CREATE INDEX ... INCLUDE ...


- Add INCLUDE clause in table definition.

   -- CREATE TABLE ... INCLUDE ...


- Add GROUPS clause and Frame exclusion syntax by adding window function features
  to complete SQL:2011 compliance.

   -- { RANGE | ROWS | GROUPS } frame_start [ frame_exclusion ]
   -- { RANGE | ROWS | GROUPS } BETWEEN frame_start AND frame_end [ frame_exclusion ]
 

- Multiple tables can be specified in one VACUUM or ANALYZE command.

  VACUUM <table1>, <table2> 
  ANALYZE <table1>, <table2> 
  
- etc. 

-- 
Bo Peng <pengbo at sraoss.co.jp>
SRA OSS, Inc. Japan
-------------- next part --------------
A non-text attachment was scrubbed...
Name: import_parser_v1.patch
Type: application/octet-stream
Size: 201737 bytes
Desc: not available
URL: <http://www.sraoss.jp/pipermail/pgpool-hackers/attachments/20180828/ec3ededf/attachment-0001.obj>