New postgres12 keyword about pglast HOT 9 CLOSED

from pglast.

But wait, are you sure you are using the v2 branch?

This is what I get with that:

$ pgpp 
WITH k AS MATERIALIZED (select * from m) select * from k
WITH k AS (SELECT *
           FROM m)

  SELECT *
  FROM k
/home/lele/wip/pglast/pglast/__init__.py:61: RuntimeWarning: Detected a non-cosmetic difference between original and prettified statements, please report
  warnings.warn("Detected a non-cosmetic difference between original and"
WITH k AS MATERIALIZED (select * from m) select * from k

from pglast.

Possibly it was my bad, I did not switch pg_query to needed commit..

Maybe next question is not part of this issue, but maybe you faced it:

After pglast v2 was succesfully installed, I have such traceback during importing pglast or using pgpp:

pgpp --help
Traceback (most recent call last):
  File "/usr/local/bin/pgpp", line 5, in <module>
    from pglast.__main__ import main
  File "/usr/local/lib/python3.7/site-packages/pglast/__init__.py", line 12, in <module>
    from .parser import get_postgresql_version, parse_plpgsql, parse_sql
ImportError: /usr/local/lib/python3.7/site-packages/pglast/parser.cpython-37m-x86_64-linux-gnu.so: undefined symbol: get_array_type

I use official python3 docker image. The same behaviour is for python:3.8.3-buster, python:3.7.8-stretch. But master branch works correctly.

from pglast.

Does the image contain bison and flex? See commit 538890f, that cured a similar problem in the CI machinery.

from pglast.

Cool) Thanks a lot) you are awesome)

from pglast.

Why did you close this? It's not solved yet, please let me do that when I have a solution 😄

from pglast.

I closed because everything you told me make it work.

Ok, I will not close it)
So from our side we are starting to test our 1k+ analytical scripts with v2. So If you need to test something on bunch of scripts, we are ready and glad to help) Just message me or Paul

from pglast.

Yes, I'm not surprised that the parser works, but pglast is still not able to print the AST back.
Thanks for the help offer! FYI, I usually hangs on #pglast on freenode.

from pglast.

Ok, this should be fixed in the v2 branch!

I'll gladly try to fix any further issue you may find with your substantial scripts collection 😄

from pglast.