Cannot setup database using db_setup.sql

[mico]

Getting error:

MacBook-Pro-Artur:instalike-instagram-bot mico$ createdb instalike
MacBook-Pro-Artur:instalike-instagram-bot mico$ psql -d instalike < db_setup.sql
CREATE TABLE
CREATE TABLE
CREATE TABLE
INSERT 0 6
CREATE TABLE
CREATE TABLE
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE TABLE
CREATE FUNCTION
CREATE TABLE
CREATE FUNCTION
CREATE TABLE
CREATE FUNCTION
CREATE TABLE
CREATE FUNCTION
CREATE FUNCTION
ALTER FUNCTION
ERROR:  syntax error at or near "on"
LINE 14: on conflict(user_id) do nothing;
         ^
ERROR:  function public.update_unfollow_queue(integer) does not exist
CREATE FUNCTION
MacBook-Pro-Artur:instalike-instagram-bot mico$ 

[mpawlak2]

Hi @mico

yeah, postgresql supports 'on conflict' from 9.5 so you probably have older version? Updated readme.

[mico]

@mpawlak2 yes, I had 9.4 updated to 9.5, that error was dissapeared