In Postgres documentation INSERT there is an example of ON CONFLICT use:
INSERT INTO distributors (did, dname) VALUES (7, 'Redline GmbH')
ON CONFLICT (did) DO NOTHING;
I try the same thing:
INSERT INTO name_map VALUES ('key_value', 'val1','val2')
ON CONFLICT (key_column) DO NOTHING;
But get ERROR: syntax error at or near "ON".
What am I missing?
postgres --version
> 9.5.0
As several people pointed out in the comments, it turns out the wrong version of postgres is running.
select version()
in psql revealed this.
There must be an old installation of 9.4.5 hiding somewhere in my system.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With