Hello, I think this change is mentioned in release notes https://www.postgresql.org/docs/release/12.0/.
čt 10. 10. 2019 v 14:51 odesílatel Ivan Kabaivanov < ivan.kabaiva...@gmail.com> napsal: > 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. >
