On 10/10/19 5:51 AM, Ivan Kabaivanov wrote:
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:
CREATETABLEhistory_configuration
(
var_name VARCHAR(50) NOTNULL,
var_value VARCHAR(255
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 wer
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/
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.kabaiva...@gmail.com> napsal:
> Hi, everyone.
>
> First time poster here.
>
> This snippet (from ovirt-engine-dwh) used to work fine wi
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,
CON
