Sorry, I wasn't sure how much information I should provide. To be thorough:
-Tanya
----------------------------------------------------------------------------
-
-- TOC Entry ID 18 (OID 16580)
--
-- Name: escalation Type: TABLE Owner: postgres
--
CREATE TABLE "escalation" (
"pathname" character varying(20) NOT NULL,
"level" smallint,
"contact" character varying(20),
"notify_method" character varying(12),
"days" character varying(12),
"hours" character varying(12),
"period" integer,
"num" integer
);
--
-- TOC Entry ID 36 (OID 16611)
--
-- Name: outages Type: TABLE Owner: postgres
--
CREATE TABLE "outages" (
"outage_id" serial NOT NULL,
"machine" character varying(30),
"service" character varying(30),
"status" character varying(12) NOT NULL,
"time" timestamp with time zone,
"owner" character varying(60),
"level" smallint DEFAULT 0 NOT NULL,
"comments" text
);
--
-- TOC Entry ID 40 (OID 16618)
--
-- Name: escalation_link Type: TABLE Owner: postgres
--
CREATE TABLE "escalation_link" (
"machine" character varying(30),
"service" character varying(30),
"status" character varying(12),
"pathname" character varying(20)
);
--
-- TOC Entry ID 41 (OID 16618)
--
-- Name: escalation_link Type: ACL Owner:
--
REVOKE ALL on "escalation_link" from PUBLIC;
GRANT ALL on "escalation_link" to "postgres";
GRANT SELECT on "escalation_link" to "ops2";
GRANT SELECT on "escalation_link" to GROUP "operators";
GRANT ALL on "escalation_link" to GROUP "opsadmins";
--
-- TOC Entry ID 37 (OID 16611)
--
-- Name: outages Type: ACL Owner:
--
REVOKE ALL on "outages" from PUBLIC;
GRANT ALL on "outages" to "postgres";
GRANT INSERT,SELECT,UPDATE,DELETE on "outages" to "ops2";
GRANT INSERT,SELECT on "outages" to GROUP "operators";
GRANT ALL on "outages" to GROUP "opsadmins";
--
-- TOC Entry ID 19 (OID 16580)
--
-- Name: escalation Type: ACL Owner:
--
REVOKE ALL on "escalation" from PUBLIC;
GRANT ALL on "escalation" to "postgres";
GRANT SELECT on "escalation" to "ops2";
GRANT SELECT on "escalation" to GROUP "operators";
-----Original Message-----
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Monday, January 26, 2004 11:59 AM
To: Tanya Mamedalin
Cc: [EMAIL PROTECTED]
Subject: Re: [BUGS] signal 11
"Tanya Mamedalin" <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
