Re: syntax error with v12

Поиск
Список
Период
Сортировка
От Josef Šimánek
Тема Re: syntax error with v12
Дата
Msg-id CAFp7Qwr2_CGFYWLFWAHgBzpehOYQoPzEt0tFf76rQAZw0iupWA@mail.gmail.com
обсуждение исходный текст
Ответ на syntax error with v12  (Ivan Kabaivanov <ivan.kabaivanov@gmail.com>)
Список pgsql-general
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.kabaivanov@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.

В списке pgsql-general по дате отправления:

Предыдущее
От: Ivan Kabaivanov
Дата:
Сообщение: syntax error with v12
Следующее
От: Félix GERZAGUET
Дата:
Сообщение: Re: syntax error with v12