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, CONSTRAINT PK_history_configuration PRIMARY KEY(var_name) ) WITH OIDS;psql:/usr/share/ovirt-engine-dwh/dbscripts/create_tables.sql:7: ERROR: syntax error at or near "OIDS" LINE 7: ) WITH OIDS;Is what I provided sufficient to troubleshoot the issue? Let me know what else must be necessary for me to add.Thanks,IvanK.
pgsql-general by date:
Соглашаюсь с условиями обработки персональных данных