[pgpool-hackers: 3008] Re: Import PostgreSQL11 parser

[Tatsuo Ishii]

Hi Peng,

Great! I have tested with the Pgpool-II regression test and all tests
passed here (Ubuntu 18 + PostgreSQL 10.5).  Please go ahead and
commit/push.

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp

> 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