syntax error with v12

From: Ivan Kabaivanov <ivan(dot)kabaivanov(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: syntax error with v12
Date: 2019-10-10 12:51:34
Message-ID: CAOHQZxt1XMwfV86ed1T0Gbb6GXQQsPFup=gFyJ0W3etKQ7-Vfw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Josef Šimánek 2019-10-10 12:53:55 Re: syntax error with v12
Previous Message Igal @ Lucee.org 2019-10-10 12:41:47 Re: Case Insensitive Comparison with Postgres 12