1.3.4: Another PostgreSQL (only ?) problem

[NOB]

Hi,

After fixing the "history_text, id" and the "alerts, alert_id" problems by
issuing the following SQL commands:

INSERT INTO ids VALUES (0,'history_text','id',1);
INSERT INTO ids VALUES (0,'alerts','alertid',1);

The next problem showed up in the zabbix_server.log file:

 44822:20070405:153354 Query::delete from trends where oid in (select oid from t
rends where itemid=17487 limit 500)
 44822:20070405:153354 Query failed:PGRES_FATAL_ERROR:ERROR:  column "oid" does 
not exist

I am using PGSQL 8.1.3 and there is no "oid" in the set of columns.
It is no longer necessary to use "oid"s and this is done in this version,
obviously.

Regards,

Norbert.

[Alexei]

Ths problem has been already discussed. PostgreSQL tables must be created with explicit OID support. It is turned off be default for PostgreSQL 8.x.

[NOB]

Hi Alexei,

thanks for the answer.
I'll try to fix it and remember it for the next beta :-)
I have to figure out whether it is possible to configure it based on tables,
databases or on the complete installation.

Regards,

Norbert.