| 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: | Whole Thread | Raw Message | 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.
| 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 |