syntax error with v12

2019-10-10 Thread Ivan Kabaivanov
Hi, everyone. First time poster here. This snippet (from ovirt-engine-dwh) used to work fine with postgresql-11.x, but emits a syntax error with postgresql-12.0: CREATE TABLE history_configuration ( var_name VARCHAR(50) NOT NULL, var_value VARCHAR(255), var_datetime TIMESTAMP WITH TIME ZONE, CON

Re: syntax error with v12

2019-10-10 Thread Ivan Kabaivanov
Thanks! ivanK. On Thu, Oct 10, 2019 at 3:56 PM Félix GERZAGUET wrote: > Hi, > > On Thu, Oct 10, 2019 at 2:51 PM Ivan Kabaivanov > wrote: > >> psql:/usr/share/ovirt-engine-dwh/dbscripts/create_tables.sql:7: ERROR: >> syntax error at or near "OIDS" >&