"Tanya Mamedalin" <tmamedalin@registrypro.pro> writes:
> Possible ways to reproduce the error: Run a multipart query similar to:
> SELECT DISTINCT o.outage_id, o.machine, o.service, o.level, o.comments,
> o2.time, e.num
> FROM outages o, outages o2, escalation e
> WHERE o.outage_id='31009'
> AND e.pathname = (SELECT pathname from escalation_link el
> WHERE el.machine=o.machine AND el.service=o.service)
> AND e.level=o.level
> AND o2.outage_id=o.outage_id
> AND o2.status in ('ALERT','WARN','CRIT','DOWN','UNKNOWN')
> ORDER BY LEVEL DESC LIMIT 1;
This is difficult to do when you have not offered the definitions of the
tables used by the query ...
regards, tom lane