search

oguimbal / pgsql-ast-parser

Yet another simple Postgres SQL parser
304 stars 43 forks source link

"on conflict" in insert statement is not supported #124

Closed sijoonlee closed 1 year ago

sijoonlee commented 1 year ago

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 1 year ago

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