oguimbal/pgsql-ast-parser

"on conflict" in insert statement is not supported

Closed this issue · 1 comments

sijoonlee commented

Here's failed SQL statement

INSERT INTO "mock-table" ( id, hello, env ) VALUES ( 1, 'hello', 'testing' ) ON CONFLICT (id) DO UPDATE SET hello = EXCLUDED.hello, env = EXCLUDED.env;·`

oguimbal commented

Hi !

Could you reopen with more context ?

Like which error you get, or a full reproduction example (with associated create table statement) that wouldnt compile on the playground, but which works on a real pg db

Because this IS supported. An example of pg-mem unit test that passes:
image