Re: syntax error with v12

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(dot)kabaivanov(at)gmail(dot)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.
>