syntax error with v12

[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,
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.

Re: syntax error with v12

[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"
>> LINE 7: ) WITH OIDS;
>>
>
> Indeed, OID were removed from 12 release as described in:
>
> https://www.postgresql.org/docs/release/12.0/
>
> You must adjust the statement.
>
> --
> Félix
>