============================================================================
POSTGRESQL BUG REPORT TEMPLATE
============================================================================
Your name : Robert Bruccoleri
Your email address : bruc@acm.org
System Configuration
---------------------
Architecture (example: Intel Pentium) : SGI Origin 3000
Operating System (example: Linux 2.0.26 ELF) : Irix 6.5.18
PostgreSQL version (example: PostgreSQL-7.3.2): PostgreSQL-7.3.2 and possibly 7.2.1
Compiler used (example: gcc 2.95.2) : MIPS Pro 7.4 and MIPS Pro 7.3.1.3, 64 bit compilation model.
Please enter a FULL description of your problem:
------------------------------------------------
The PostgreSQL backend core dumps reproducibly with a set of LOCK commands that
would normally deadlock.
The following debugging session on the core dump shows some details:
nunu postgres 101 >>dbx /pg/postgresql-7.3.2/bin/postgres
dbx version 7.3.3 (78517_Dec16 MR) Dec 16 2001 07:45:22
Core from signal SIGBUS: Bus error
file foo.dbx already exists, appending
[3] record input foo.dbx (0 lines)
warning: file foo.dbx already exists, appending
[4] record output foo.dbx (0 lines)
(dbx) where
> 0 ExpandConstraints(constraints = 0x1041ad58, nConstraints = 1)
["/pg/postgresql-7.3.2/src/backend/storage/lmgr/deadlock.c":586,0x101df1ec]
1 TestConfiguration(startProc = 0x8006483ebf8) ["/pg/postgresql-7.3.2/src/backend/storage/lmgr/deadlock.c":322,
0x101de90c]
2 DeadLockCheckRecurse(proc = 0x8006483ebf8) ["/pg/postgresql-7.3.2/src/backend/storage/lmgr/deadlock.c":246,
0x101de698]
3 DeadLockCheckRecurse(proc = 0x8006483ebf8) ["/pg/postgresql-7.3.2/src/backend/storage/lmgr/deadlock.c":280,
0x101de828]
4 DeadLockCheck(proc = 0x8006483ebf8) ["/pg/postgresql-7.3.2/src/backend/storage/lmgr/deadlock.c":192, 0x101de4a4]
5 CheckDeadLock() ["/pg/postgresql-7.3.2/src/backend/storage/lmgr/proc.c":843, 0x101dd9d0]
6 handle_sig_alarm(postgres_signal_arg = 14) ["/pg/postgresql-7.3.2/src/backend/storage/lmgr/proc.c":1145,
0x101de280]
7 _sigtramp(0xc, 0x1, 0xda710a4, 0x7f7f7f7f7f7f7f7f, 0x1034fe50, 0xe, 0x1, 0x9)
["/xlv14/patches/4847/work/irix/lib/libc/libc_64_M4/signal/sigtramp.s":71,0xda6250c]
8 __syscall(0x41d, 0x2, 0xf1, 0x1, 0x72, 0x75, 0x80044833070, 0x1)
["/xlv14/patches/4847/work/irix/lib/libc/libc_64_M4/sys/syscall.s":20,0xda93178]
9 _semop(0xf1, 0xffffffcca30, 0x1, 0x1, 0x72, 0x75, 0x80044833070, 0x1)
["/xlv14/patches/4847/work/irix/lib/libc/libc_64_M4/sys/semsys.c":62,0xda946a4]
10 PGSemaphoreLock(sema = 0x8006483ec08, interruptOK = '\001')
["/pg/postgresql-7.3.2/src/backend/port/pg_sema.c":434,0x101a8d8c]
11 ProcSleep(lockMethodTable = 0x800648367c8, lockmode = 8, lock = 0x80064861480, holder = 0x800648625d0)
["/pg/postgresql-7.3.2/src/backend/storage/lmgr/proc.c":673,0x101dd5e8]
12 WaitOnLock(lockmethod = 1, lockmode = 8, lock = 0x80064861480, holder = 0x800648625d0)
["/pg/postgresql-7.3.2/src/backend/storage/lmgr/lock.c":896,0x101daa34]
13 LockAcquire(lockmethod = 1, locktag = 0xffffffccc58, xid = 5681, lockmode = 8, dontWait = '')
["/pg/postgresql-7.3.2/src/backend/storage/lmgr/lock.c":685,0x101da294]
14 LockRelation(relation = 0x104bc560, lockmode = 8) ["/pg/postgresql-7.3.2/src/backend/storage/lmgr/lmgr.c":133,
0x101d81c8]
15 relation_open(relationId = 23467, lockmode = 8) ["/pg/postgresql-7.3.2/src/backend/access/heap/heapam.c":477,
0x1005b46c]
16 LockTableCommand(lockstmt = 0x104c12d8) ["/pg/postgresql-7.3.2/src/backend/commands/lockcmds.c":61, 0x101061e4]
17 ProcessUtility(parsetree = 0x104c12d8, dest = Remote=2, completionTag = 0xffffffccf18 = "")
["/pg/postgresql-7.3.2/src/backend/tcop/utility.c":806,0x101eb498]
18 pg_exec_query_string(query_string = 0x104c1010, dest = Remote=2, parse_context = 0x104bf120)
["/pg/postgresql-7.3.2/src/backend/tcop/postgres.c":789,0x101e6cc8]
19 PostgresMain(argc = 4, argv = 0xffffffcd0c0, username = 0x103bf1a9 = "bruc")
["/pg/postgresql-7.3.2/src/backend/tcop/postgres.c":2013,0x101e8be4]
20 DoBackend(port = 0x103bf078) ["/pg/postgresql-7.3.2/src/backend/postmaster/postmaster.c":2302, 0x101ad4c4]
21 BackendStartup(port = 0x103bf078) ["/pg/postgresql-7.3.2/src/backend/postmaster/postmaster.c":1924, 0x101ac8ec]
22 ServerLoop() ["/pg/postgresql-7.3.2/src/backend/postmaster/postmaster.c":1027, 0x101aae58]
23 PostmasterMain(argc = 8, argv = 0x103b3f98) ["/pg/postgresql-7.3.2/src/backend/postmaster/postmaster.c":788,
0x101aa6c4]
24 main(argc = 8, argv = 0xffffffcdde8) ["/pg/postgresql-7.3.2/src/backend/main/main.c":210, 0x1015fed4]
25 __start() ["/xlv55/kudzu-apr12/work/irix/lib/libc/libc_64_M4/csu/crt1text.s":177, 0x10032c78]
(dbx) l 570,590
570 int nConstraints)
571 {
572 int nWaitOrderProcs = 0;
573 int i,
574 j;
575
576 nWaitOrders = 0;
577
578 /*
579 * Scan constraint list backwards. This is because the last-added
580 * constraint is the only one that could fail, and so we want to test
581 * it for inconsistency first.
582 */
583 for (i = nConstraints; --i >= 0;)
584 {
585 PGPROC *proc = constraints[i].waiter;
* 586 LOCK *lock = proc->waitLock;
587
588 /* Did we already make a list for this lock? */
589 for (j = nWaitOrders; --j >= 0;)
590 {
(dbx) p proc
0x7f7f7f7f7f7f7f7f
(dbx) p constraints[0]
struct {waiter = 0x7f7f7f7f7f7f7f7f, blocker = 0x7f7f7f7f7f7f7f7f, pred = 2139062143, link = 2139062143}
(dbx) p constraints[1]
struct {waiter = 0x7f7f7f7f7f7f7f7f, blocker = 0x7f7f7f7f7f7f7f7f, pred = 2139062143, link = 2139062143}
(dbx) p i
0
(dbx) p nConstraints
1
Please describe a way to repeat the problem. Please try to provide a
concise reproducible example, if at all possible:
----------------------------------------------------------------------
0) Create a user named tilfordc with all rights.
1) Construct a database using the 'maptracker.sql' schema attached to this message.
Use the name, 'maptracker', as an example.
2) Start two psql sessions on maptracker. Issue "BEGIN;" commands in both.
3) In session 1, type "lock mapping;".
4) In session 2, type "lock location;" and then "lock mapping;"
5) In session 1, type "lock location;". The backend will crash in a few seconds.
If you know how this problem might be fixed, list the solution below:
---------------------------------------------------------------------
+-----------------------------+------------------------------------+
| Robert E. Bruccoleri, Ph.D. | email: bruc@acm.org |
| President, Congenomics Inc. | URL: http://www.congen.com/~bruc |
| P.O. Box 314 | Phone: 609 818 7251 |
| Pennington, NJ 08534 | |
+-----------------------------+------------------------------------+
--
-- PostgreSQL database dump
--
\connect - tilfordc
SET search_path = public, pg_catalog;
--
-- TOC entry 2 (OID 23419)
-- Name: seqname_seq; Type: SEQUENCE; Schema: public; Owner: tilfordc
--
CREATE SEQUENCE seqname_seq
START 1
INCREMENT 1
MAXVALUE 9223372036854775807
MINVALUE 1
CACHE 1;
--
-- TOC entry 3 (OID 23421)
-- Name: class_list_seq; Type: SEQUENCE; Schema: public; Owner: tilfordc
--
CREATE SEQUENCE class_list_seq
START 1
INCREMENT 1
MAXVALUE 9223372036854775807
MINVALUE 1
CACHE 1;
--
-- TOC entry 4 (OID 23423)
-- Name: transform_seq; Type: SEQUENCE; Schema: public; Owner: tilfordc
--
CREATE SEQUENCE transform_seq
START 1
INCREMENT 1
MAXVALUE 9223372036854775807
MINVALUE 1
CACHE 1;
--
-- TOC entry 5 (OID 23425)
-- Name: authority_seq; Type: SEQUENCE; Schema: public; Owner: tilfordc
--
CREATE SEQUENCE authority_seq
START 1
INCREMENT 1
MAXVALUE 9223372036854775807
MINVALUE 1
CACHE 1;
--
-- TOC entry 6 (OID 23427)
-- Name: relationship_seq; Type: SEQUENCE; Schema: public; Owner: tilfordc
--
CREATE SEQUENCE relationship_seq
START 1
INCREMENT 1
MAXVALUE 9223372036854775807
MINVALUE 1
CACHE 1;
--
-- TOC entry 7 (OID 23429)
-- Name: mapping_seq; Type: SEQUENCE; Schema: public; Owner: tilfordc
--
CREATE SEQUENCE mapping_seq
START 1
INCREMENT 1
MAXVALUE 9223372036854775807
MINVALUE 1
CACHE 1;
--
-- TOC entry 8 (OID 23431)
-- Name: authority; Type: TABLE; Schema: public; Owner: tilfordc
--
CREATE TABLE authority (
authority_id integer NOT NULL,
upper_name character varying(100),
authname character varying(100),
descr character varying(255)
);
--
-- TOC entry 9 (OID 23435)
-- Name: class_list; Type: TABLE; Schema: public; Owner: tilfordc
--
CREATE TABLE class_list (
class_id integer NOT NULL,
parent_id integer,
seqclass character varying(20),
descr character varying(255)
);
--
-- TOC entry 10 (OID 23439)
-- Name: relationship; Type: TABLE; Schema: public; Owner: tilfordc
--
CREATE TABLE relationship (
type_id integer NOT NULL,
label character varying(20),
reads_forward character varying(50),
reads_backward character varying(50),
class1 integer,
class2 integer,
descr character varying(255)
);
--
-- TOC entry 11 (OID 23443)
-- Name: seqname; Type: TABLE; Schema: public; Owner: tilfordc
--
CREATE TABLE seqname (
name_id integer NOT NULL,
upper_name character varying(100),
seqname character varying(100)
);
--
-- TOC entry 12 (OID 23447)
-- Name: species; Type: TABLE; Schema: public; Owner: tilfordc
--
CREATE TABLE species (
tax_id integer NOT NULL,
taxa_name character varying(255),
upper_taxa character varying(255)
);
--
-- TOC entry 13 (OID 23451)
-- Name: species_alias; Type: TABLE; Schema: public; Owner: tilfordc
--
CREATE TABLE species_alias (
tax_id integer,
alias character varying(255),
name_class character varying(50)
);
--
-- TOC entry 14 (OID 23453)
-- Name: transform; Type: TABLE; Schema: public; Owner: tilfordc
--
CREATE TABLE transform (
trans_id integer NOT NULL,
transname character varying(50),
step1 double precision,
step2 double precision
);
--
-- TOC entry 15 (OID 23457)
-- Name: relation; Type: TABLE; Schema: public; Owner: tilfordc
--
CREATE TABLE relation (
name1 integer,
name2 integer,
type_id integer,
authority_id integer
);
--
-- TOC entry 16 (OID 23459)
-- Name: seq_class; Type: TABLE; Schema: public; Owner: tilfordc
--
CREATE TABLE seq_class (
class_id integer,
name_id integer,
authority_id integer
);
--
-- TOC entry 17 (OID 23461)
-- Name: seq_species; Type: TABLE; Schema: public; Owner: tilfordc
--
CREATE TABLE seq_species (
tax_id integer,
name_id integer,
authority_id integer
);
--
-- TOC entry 18 (OID 23463)
-- Name: mapping; Type: TABLE; Schema: public; Owner: tilfordc
--
CREATE TABLE mapping (
map_id integer NOT NULL,
name1 integer,
start1 double precision,
end1 double precision,
name2 integer,
start2 double precision,
end2 double precision,
trans_id integer,
authority_id integer,
map_score double precision,
strand integer
);
--
-- TOC entry 19 (OID 23467)
-- Name: location; Type: TABLE; Schema: public; Owner: tilfordc
--
CREATE TABLE "location" (
map_id integer,
start1 double precision,
end1 double precision,
start2 double precision
);
--
-- TOC entry 21 (OID 3260248)
-- Name: u_thrty_pprnm; Type: INDEX; Schema: public; Owner: tilfordc
--
CREATE UNIQUE INDEX u_thrty_pprnm ON authority USING btree (upper_name);
--
-- TOC entry 23 (OID 3260249)
-- Name: u_clsslst_sqclss; Type: INDEX; Schema: public; Owner: tilfordc
--
CREATE UNIQUE INDEX u_clsslst_sqclss ON class_list USING btree (seqclass);
--
-- TOC entry 27 (OID 3260250)
-- Name: u_rltnshp_lbl; Type: INDEX; Schema: public; Owner: tilfordc
--
CREATE UNIQUE INDEX u_rltnshp_lbl ON relationship USING btree (label);
--
-- TOC entry 24 (OID 3260251)
-- Name: ifk_rltnshp_clss1; Type: INDEX; Schema: public; Owner: tilfordc
--
CREATE INDEX ifk_rltnshp_clss1 ON relationship USING btree (class1);
--
-- TOC entry 25 (OID 3260252)
-- Name: ifk_rltnshp_clss2; Type: INDEX; Schema: public; Owner: tilfordc
--
CREATE INDEX ifk_rltnshp_clss2 ON relationship USING btree (class2);
--
-- TOC entry 29 (OID 3260253)
-- Name: u_sqnm_pprnm; Type: INDEX; Schema: public; Owner: tilfordc
--
CREATE UNIQUE INDEX u_sqnm_pprnm ON seqname USING btree (upper_name);
--
-- TOC entry 31 (OID 3260254)
-- Name: ifk_spcsls_txd; Type: INDEX; Schema: public; Owner: tilfordc
--
CREATE INDEX ifk_spcsls_txd ON species_alias USING btree (tax_id);
--
-- TOC entry 33 (OID 3260255)
-- Name: rltn_nm1nm2; Type: INDEX; Schema: public; Owner: tilfordc
--
CREATE INDEX rltn_nm1nm2 ON relation USING btree (name1, name2);
--
-- TOC entry 35 (OID 3260256)
-- Name: sqclss_nmd; Type: INDEX; Schema: public; Owner: tilfordc
--
CREATE INDEX sqclss_nmd ON seq_class USING btree (name_id);
--
-- TOC entry 36 (OID 3260257)
-- Name: sqspcs_nmd; Type: INDEX; Schema: public; Owner: tilfordc
--
CREATE INDEX sqspcs_nmd ON seq_species USING btree (name_id);
--
-- TOC entry 38 (OID 3260258)
-- Name: mppng_nm1strt1nd1; Type: INDEX; Schema: public; Owner: tilfordc
--
CREATE INDEX mppng_nm1strt1nd1 ON mapping USING btree (name1, start1, end1);
--
-- TOC entry 39 (OID 3260259)
-- Name: mppng_nm2strt2nd2; Type: INDEX; Schema: public; Owner: tilfordc
--
CREATE INDEX mppng_nm2strt2nd2 ON mapping USING btree (name2, start2, end2);
--
-- TOC entry 37 (OID 3260260)
-- Name: mppng_nm1nm2; Type: INDEX; Schema: public; Owner: tilfordc
--
CREATE INDEX mppng_nm1nm2 ON mapping USING btree (name1, name2);
--
-- TOC entry 41 (OID 3260261)
-- Name: ifk_lctn_mpd; Type: INDEX; Schema: public; Owner: tilfordc
--
CREATE INDEX ifk_lctn_mpd ON "location" USING btree (map_id);
--
-- TOC entry 34 (OID 3260262)
-- Name: rltn_nm2; Type: INDEX; Schema: public; Owner: tilfordc
--
CREATE INDEX rltn_nm2 ON relation USING btree (name2);
--
-- TOC entry 20 (OID 23433)
-- Name: pk_thrty_thrtyd; Type: CONSTRAINT; Schema: public; Owner: tilfordc
--
ALTER TABLE ONLY authority
ADD CONSTRAINT pk_thrty_thrtyd PRIMARY KEY (authority_id);
--
-- TOC entry 22 (OID 23437)
-- Name: pk_clsslst_clssd; Type: CONSTRAINT; Schema: public; Owner: tilfordc
--
ALTER TABLE ONLY class_list
ADD CONSTRAINT pk_clsslst_clssd PRIMARY KEY (class_id);
--
-- TOC entry 26 (OID 23441)
-- Name: pk_rltnshp_typd; Type: CONSTRAINT; Schema: public; Owner: tilfordc
--
ALTER TABLE ONLY relationship
ADD CONSTRAINT pk_rltnshp_typd PRIMARY KEY (type_id);
--
-- TOC entry 28 (OID 23445)
-- Name: pk_sqnm_nmd; Type: CONSTRAINT; Schema: public; Owner: tilfordc
--
ALTER TABLE ONLY seqname
ADD CONSTRAINT pk_sqnm_nmd PRIMARY KEY (name_id);
--
-- TOC entry 30 (OID 23449)
-- Name: pk_spcs_txd; Type: CONSTRAINT; Schema: public; Owner: tilfordc
--
ALTER TABLE ONLY species
ADD CONSTRAINT pk_spcs_txd PRIMARY KEY (tax_id);
--
-- TOC entry 32 (OID 23455)
-- Name: pk_trnsfrm_trnsd; Type: CONSTRAINT; Schema: public; Owner: tilfordc
--
ALTER TABLE ONLY transform
ADD CONSTRAINT pk_trnsfrm_trnsd PRIMARY KEY (trans_id);
--
-- TOC entry 40 (OID 23465)
-- Name: pk_mppng_mpd; Type: CONSTRAINT; Schema: public; Owner: tilfordc
--
ALTER TABLE ONLY mapping
ADD CONSTRAINT pk_mppng_mpd PRIMARY KEY (map_id);
--
-- TOC entry 56 (OID 3260263)
-- Name: RI_ConstraintTrigger_3260263; Type: TRIGGER; Schema: public; Owner: tilfordc
--
CREATE CONSTRAINT TRIGGER "<unnamed>"
AFTER INSERT OR UPDATE ON relationship
FROM class_list
NOT DEFERRABLE INITIALLY IMMEDIATE
FOR EACH ROW
EXECUTE PROCEDURE "RI_FKey_check_ins" ('<unnamed>', 'relationship', 'class_list', 'UNSPECIFIED', 'class1',
'class_id');
--
-- TOC entry 50 (OID 3260264)
-- Name: RI_ConstraintTrigger_3260264; Type: TRIGGER; Schema: public; Owner: tilfordc
--
CREATE CONSTRAINT TRIGGER "<unnamed>"
AFTER DELETE ON class_list
FROM relationship
NOT DEFERRABLE INITIALLY IMMEDIATE
FOR EACH ROW
EXECUTE PROCEDURE "RI_FKey_noaction_del" ('<unnamed>', 'relationship', 'class_list', 'UNSPECIFIED', 'class1',
'class_id');
--
-- TOC entry 51 (OID 3260265)
-- Name: RI_ConstraintTrigger_3260265; Type: TRIGGER; Schema: public; Owner: tilfordc
--
CREATE CONSTRAINT TRIGGER "<unnamed>"
AFTER UPDATE ON class_list
FROM relationship
NOT DEFERRABLE INITIALLY IMMEDIATE
FOR EACH ROW
EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('<unnamed>', 'relationship', 'class_list', 'UNSPECIFIED', 'class1',
'class_id');
--
-- TOC entry 57 (OID 3260266)
-- Name: RI_ConstraintTrigger_3260266; Type: TRIGGER; Schema: public; Owner: tilfordc
--
CREATE CONSTRAINT TRIGGER "<unnamed>"
AFTER INSERT OR UPDATE ON relationship
FROM class_list
NOT DEFERRABLE INITIALLY IMMEDIATE
FOR EACH ROW
EXECUTE PROCEDURE "RI_FKey_check_ins" ('<unnamed>', 'relationship', 'class_list', 'UNSPECIFIED', 'class2',
'class_id');
--
-- TOC entry 52 (OID 3260267)
-- Name: RI_ConstraintTrigger_3260267; Type: TRIGGER; Schema: public; Owner: tilfordc
--
CREATE CONSTRAINT TRIGGER "<unnamed>"
AFTER DELETE ON class_list
FROM relationship
NOT DEFERRABLE INITIALLY IMMEDIATE
FOR EACH ROW
EXECUTE PROCEDURE "RI_FKey_noaction_del" ('<unnamed>', 'relationship', 'class_list', 'UNSPECIFIED', 'class2',
'class_id');
--
-- TOC entry 53 (OID 3260268)
-- Name: RI_ConstraintTrigger_3260268; Type: TRIGGER; Schema: public; Owner: tilfordc
--
CREATE CONSTRAINT TRIGGER "<unnamed>"
AFTER UPDATE ON class_list
FROM relationship
NOT DEFERRABLE INITIALLY IMMEDIATE
FOR EACH ROW
EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('<unnamed>', 'relationship', 'class_list', 'UNSPECIFIED', 'class2',
'class_id');
--
-- TOC entry 74 (OID 3260269)
-- Name: RI_ConstraintTrigger_3260269; Type: TRIGGER; Schema: public; Owner: tilfordc
--
CREATE CONSTRAINT TRIGGER "<unnamed>"
AFTER INSERT OR UPDATE ON species_alias
FROM species
NOT DEFERRABLE INITIALLY IMMEDIATE
FOR EACH ROW
EXECUTE PROCEDURE "RI_FKey_check_ins" ('<unnamed>', 'species_alias', 'species', 'UNSPECIFIED', 'tax_id', 'tax_id');
--
-- TOC entry 72 (OID 3260270)
-- Name: RI_ConstraintTrigger_3260270; Type: TRIGGER; Schema: public; Owner: tilfordc
--
CREATE CONSTRAINT TRIGGER "<unnamed>"
AFTER DELETE ON species
FROM species_alias
NOT DEFERRABLE INITIALLY IMMEDIATE
FOR EACH ROW
EXECUTE PROCEDURE "RI_FKey_noaction_del" ('<unnamed>', 'species_alias', 'species', 'UNSPECIFIED', 'tax_id',
'tax_id');
--
-- TOC entry 73 (OID 3260271)
-- Name: RI_ConstraintTrigger_3260271; Type: TRIGGER; Schema: public; Owner: tilfordc
--
CREATE CONSTRAINT TRIGGER "<unnamed>"
AFTER UPDATE ON species
FROM species_alias
NOT DEFERRABLE INITIALLY IMMEDIATE
FOR EACH ROW
EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('<unnamed>', 'species_alias', 'species', 'UNSPECIFIED', 'tax_id',
'tax_id');
--
-- TOC entry 77 (OID 3260272)
-- Name: RI_ConstraintTrigger_3260272; Type: TRIGGER; Schema: public; Owner: tilfordc
--
CREATE CONSTRAINT TRIGGER "<unnamed>"
AFTER INSERT OR UPDATE ON relation
FROM seqname
NOT DEFERRABLE INITIALLY IMMEDIATE
FOR EACH ROW
EXECUTE PROCEDURE "RI_FKey_check_ins" ('<unnamed>', 'relation', 'seqname', 'UNSPECIFIED', 'name1', 'name_id');
--
-- TOC entry 60 (OID 3260273)
-- Name: RI_ConstraintTrigger_3260273; Type: TRIGGER; Schema: public; Owner: tilfordc
--
CREATE CONSTRAINT TRIGGER "<unnamed>"
AFTER DELETE ON seqname
FROM relation
NOT DEFERRABLE INITIALLY IMMEDIATE
FOR EACH ROW
EXECUTE PROCEDURE "RI_FKey_noaction_del" ('<unnamed>', 'relation', 'seqname', 'UNSPECIFIED', 'name1', 'name_id');
--
-- TOC entry 61 (OID 3260274)
-- Name: RI_ConstraintTrigger_3260274; Type: TRIGGER; Schema: public; Owner: tilfordc
--
CREATE CONSTRAINT TRIGGER "<unnamed>"
AFTER UPDATE ON seqname
FROM relation
NOT DEFERRABLE INITIALLY IMMEDIATE
FOR EACH ROW
EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('<unnamed>', 'relation', 'seqname', 'UNSPECIFIED', 'name1', 'name_id');
--
-- TOC entry 78 (OID 3260275)
-- Name: RI_ConstraintTrigger_3260275; Type: TRIGGER; Schema: public; Owner: tilfordc
--
CREATE CONSTRAINT TRIGGER "<unnamed>"
AFTER INSERT OR UPDATE ON relation
FROM seqname
NOT DEFERRABLE INITIALLY IMMEDIATE
FOR EACH ROW
EXECUTE PROCEDURE "RI_FKey_check_ins" ('<unnamed>', 'relation', 'seqname', 'UNSPECIFIED', 'name2', 'name_id');
--
-- TOC entry 62 (OID 3260276)
-- Name: RI_ConstraintTrigger_3260276; Type: TRIGGER; Schema: public; Owner: tilfordc
--
CREATE CONSTRAINT TRIGGER "<unnamed>"
AFTER DELETE ON seqname
FROM relation
NOT DEFERRABLE INITIALLY IMMEDIATE
FOR EACH ROW
EXECUTE PROCEDURE "RI_FKey_noaction_del" ('<unnamed>', 'relation', 'seqname', 'UNSPECIFIED', 'name2', 'name_id');
--
-- TOC entry 63 (OID 3260277)
-- Name: RI_ConstraintTrigger_3260277; Type: TRIGGER; Schema: public; Owner: tilfordc
--
CREATE CONSTRAINT TRIGGER "<unnamed>"
AFTER UPDATE ON seqname
FROM relation
NOT DEFERRABLE INITIALLY IMMEDIATE
FOR EACH ROW
EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('<unnamed>', 'relation', 'seqname', 'UNSPECIFIED', 'name2', 'name_id');
--
-- TOC entry 79 (OID 3260278)
-- Name: RI_ConstraintTrigger_3260278; Type: TRIGGER; Schema: public; Owner: tilfordc
--
CREATE CONSTRAINT TRIGGER "<unnamed>"
AFTER INSERT OR UPDATE ON relation
FROM relationship
NOT DEFERRABLE INITIALLY IMMEDIATE
FOR EACH ROW
EXECUTE PROCEDURE "RI_FKey_check_ins" ('<unnamed>', 'relation', 'relationship', 'UNSPECIFIED', 'type_id',
'type_id');
--
-- TOC entry 58 (OID 3260279)
-- Name: RI_ConstraintTrigger_3260279; Type: TRIGGER; Schema: public; Owner: tilfordc
--
CREATE CONSTRAINT TRIGGER "<unnamed>"
AFTER DELETE ON relationship
FROM relation
NOT DEFERRABLE INITIALLY IMMEDIATE
FOR EACH ROW
EXECUTE PROCEDURE "RI_FKey_noaction_del" ('<unnamed>', 'relation', 'relationship', 'UNSPECIFIED', 'type_id',
'type_id');
--
-- TOC entry 59 (OID 3260280)
-- Name: RI_ConstraintTrigger_3260280; Type: TRIGGER; Schema: public; Owner: tilfordc
--
CREATE CONSTRAINT TRIGGER "<unnamed>"
AFTER UPDATE ON relationship
FROM relation
NOT DEFERRABLE INITIALLY IMMEDIATE
FOR EACH ROW
EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('<unnamed>', 'relation', 'relationship', 'UNSPECIFIED', 'type_id',
'type_id');
--
-- TOC entry 80 (OID 3260281)
-- Name: RI_ConstraintTrigger_3260281; Type: TRIGGER; Schema: public; Owner: tilfordc
--
CREATE CONSTRAINT TRIGGER "<unnamed>"
AFTER INSERT OR UPDATE ON relation
FROM authority
NOT DEFERRABLE INITIALLY IMMEDIATE
FOR EACH ROW
EXECUTE PROCEDURE "RI_FKey_check_ins" ('<unnamed>', 'relation', 'authority', 'UNSPECIFIED', 'authority_id',
'authority_id');
--
-- TOC entry 42 (OID 3260282)
-- Name: RI_ConstraintTrigger_3260282; Type: TRIGGER; Schema: public; Owner: tilfordc
--
CREATE CONSTRAINT TRIGGER "<unnamed>"
AFTER DELETE ON authority
FROM relation
NOT DEFERRABLE INITIALLY IMMEDIATE
FOR EACH ROW
EXECUTE PROCEDURE "RI_FKey_noaction_del" ('<unnamed>', 'relation', 'authority', 'UNSPECIFIED', 'authority_id',
'authority_id');
--
-- TOC entry 43 (OID 3260283)
-- Name: RI_ConstraintTrigger_3260283; Type: TRIGGER; Schema: public; Owner: tilfordc
--
CREATE CONSTRAINT TRIGGER "<unnamed>"
AFTER UPDATE ON authority
FROM relation
NOT DEFERRABLE INITIALLY IMMEDIATE
FOR EACH ROW
EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('<unnamed>', 'relation', 'authority', 'UNSPECIFIED', 'authority_id',
'authority_id');
--
-- TOC entry 81 (OID 3260284)
-- Name: RI_ConstraintTrigger_3260284; Type: TRIGGER; Schema: public; Owner: tilfordc
--
CREATE CONSTRAINT TRIGGER "<unnamed>"
AFTER INSERT OR UPDATE ON seq_class
FROM class_list
NOT DEFERRABLE INITIALLY IMMEDIATE
FOR EACH ROW
EXECUTE PROCEDURE "RI_FKey_check_ins" ('<unnamed>', 'seq_class', 'class_list', 'UNSPECIFIED', 'class_id',
'class_id');
--
-- TOC entry 54 (OID 3260285)
-- Name: RI_ConstraintTrigger_3260285; Type: TRIGGER; Schema: public; Owner: tilfordc
--
CREATE CONSTRAINT TRIGGER "<unnamed>"
AFTER DELETE ON class_list
FROM seq_class
NOT DEFERRABLE INITIALLY IMMEDIATE
FOR EACH ROW
EXECUTE PROCEDURE "RI_FKey_noaction_del" ('<unnamed>', 'seq_class', 'class_list', 'UNSPECIFIED', 'class_id',
'class_id');
--
-- TOC entry 55 (OID 3260286)
-- Name: RI_ConstraintTrigger_3260286; Type: TRIGGER; Schema: public; Owner: tilfordc
--
CREATE CONSTRAINT TRIGGER "<unnamed>"
AFTER UPDATE ON class_list
FROM seq_class
NOT DEFERRABLE INITIALLY IMMEDIATE
FOR EACH ROW
EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('<unnamed>', 'seq_class', 'class_list', 'UNSPECIFIED', 'class_id',
'class_id');
--
-- TOC entry 82 (OID 3260287)
-- Name: RI_ConstraintTrigger_3260287; Type: TRIGGER; Schema: public; Owner: tilfordc
--
CREATE CONSTRAINT TRIGGER "<unnamed>"
AFTER INSERT OR UPDATE ON seq_class
FROM seqname
NOT DEFERRABLE INITIALLY IMMEDIATE
FOR EACH ROW
EXECUTE PROCEDURE "RI_FKey_check_ins" ('<unnamed>', 'seq_class', 'seqname', 'UNSPECIFIED', 'name_id', 'name_id');
--
-- TOC entry 64 (OID 3260288)
-- Name: RI_ConstraintTrigger_3260288; Type: TRIGGER; Schema: public; Owner: tilfordc
--
CREATE CONSTRAINT TRIGGER "<unnamed>"
AFTER DELETE ON seqname
FROM seq_class
NOT DEFERRABLE INITIALLY IMMEDIATE
FOR EACH ROW
EXECUTE PROCEDURE "RI_FKey_noaction_del" ('<unnamed>', 'seq_class', 'seqname', 'UNSPECIFIED', 'name_id',
'name_id');
--
-- TOC entry 65 (OID 3260289)
-- Name: RI_ConstraintTrigger_3260289; Type: TRIGGER; Schema: public; Owner: tilfordc
--
CREATE CONSTRAINT TRIGGER "<unnamed>"
AFTER UPDATE ON seqname
FROM seq_class
NOT DEFERRABLE INITIALLY IMMEDIATE
FOR EACH ROW
EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('<unnamed>', 'seq_class', 'seqname', 'UNSPECIFIED', 'name_id',
'name_id');
--
-- TOC entry 83 (OID 3260290)
-- Name: RI_ConstraintTrigger_3260290; Type: TRIGGER; Schema: public; Owner: tilfordc
--
CREATE CONSTRAINT TRIGGER "<unnamed>"
AFTER INSERT OR UPDATE ON seq_class
FROM authority
NOT DEFERRABLE INITIALLY IMMEDIATE
FOR EACH ROW
EXECUTE PROCEDURE "RI_FKey_check_ins" ('<unnamed>', 'seq_class', 'authority', 'UNSPECIFIED', 'authority_id',
'authority_id');
--
-- TOC entry 44 (OID 3260291)
-- Name: RI_ConstraintTrigger_3260291; Type: TRIGGER; Schema: public; Owner: tilfordc
--
CREATE CONSTRAINT TRIGGER "<unnamed>"
AFTER DELETE ON authority
FROM seq_class
NOT DEFERRABLE INITIALLY IMMEDIATE
FOR EACH ROW
EXECUTE PROCEDURE "RI_FKey_noaction_del" ('<unnamed>', 'seq_class', 'authority', 'UNSPECIFIED', 'authority_id',
'authority_id');
--
-- TOC entry 45 (OID 3260292)
-- Name: RI_ConstraintTrigger_3260292; Type: TRIGGER; Schema: public; Owner: tilfordc
--
CREATE CONSTRAINT TRIGGER "<unnamed>"
AFTER UPDATE ON authority
FROM seq_class
NOT DEFERRABLE INITIALLY IMMEDIATE
FOR EACH ROW
EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('<unnamed>', 'seq_class', 'authority', 'UNSPECIFIED', 'authority_id',
'authority_id');
--
-- TOC entry 84 (OID 3260293)
-- Name: RI_ConstraintTrigger_3260293; Type: TRIGGER; Schema: public; Owner: tilfordc
--
CREATE CONSTRAINT TRIGGER "<unnamed>"
AFTER INSERT OR UPDATE ON seq_species
FROM seqname
NOT DEFERRABLE INITIALLY IMMEDIATE
FOR EACH ROW
EXECUTE PROCEDURE "RI_FKey_check_ins" ('<unnamed>', 'seq_species', 'seqname', 'UNSPECIFIED', 'name_id', 'name_id');
--
-- TOC entry 66 (OID 3260294)
-- Name: RI_ConstraintTrigger_3260294; Type: TRIGGER; Schema: public; Owner: tilfordc
--
CREATE CONSTRAINT TRIGGER "<unnamed>"
AFTER DELETE ON seqname
FROM seq_species
NOT DEFERRABLE INITIALLY IMMEDIATE
FOR EACH ROW
EXECUTE PROCEDURE "RI_FKey_noaction_del" ('<unnamed>', 'seq_species', 'seqname', 'UNSPECIFIED', 'name_id',
'name_id');
--
-- TOC entry 67 (OID 3260295)
-- Name: RI_ConstraintTrigger_3260295; Type: TRIGGER; Schema: public; Owner: tilfordc
--
CREATE CONSTRAINT TRIGGER "<unnamed>"
AFTER UPDATE ON seqname
FROM seq_species
NOT DEFERRABLE INITIALLY IMMEDIATE
FOR EACH ROW
EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('<unnamed>', 'seq_species', 'seqname', 'UNSPECIFIED', 'name_id',
'name_id');
--
-- TOC entry 85 (OID 3260296)
-- Name: RI_ConstraintTrigger_3260296; Type: TRIGGER; Schema: public; Owner: tilfordc
--
CREATE CONSTRAINT TRIGGER "<unnamed>"
AFTER INSERT OR UPDATE ON seq_species
FROM authority
NOT DEFERRABLE INITIALLY IMMEDIATE
FOR EACH ROW
EXECUTE PROCEDURE "RI_FKey_check_ins" ('<unnamed>', 'seq_species', 'authority', 'UNSPECIFIED', 'authority_id',
'authority_id');
--
-- TOC entry 46 (OID 3260297)
-- Name: RI_ConstraintTrigger_3260297; Type: TRIGGER; Schema: public; Owner: tilfordc
--
CREATE CONSTRAINT TRIGGER "<unnamed>"
AFTER DELETE ON authority
FROM seq_species
NOT DEFERRABLE INITIALLY IMMEDIATE
FOR EACH ROW
EXECUTE PROCEDURE "RI_FKey_noaction_del" ('<unnamed>', 'seq_species', 'authority', 'UNSPECIFIED', 'authority_id',
'authority_id');
--
-- TOC entry 47 (OID 3260298)
-- Name: RI_ConstraintTrigger_3260298; Type: TRIGGER; Schema: public; Owner: tilfordc
--
CREATE CONSTRAINT TRIGGER "<unnamed>"
AFTER UPDATE ON authority
FROM seq_species
NOT DEFERRABLE INITIALLY IMMEDIATE
FOR EACH ROW
EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('<unnamed>', 'seq_species', 'authority', 'UNSPECIFIED', 'authority_id',
'authority_id');
--
-- TOC entry 86 (OID 3260299)
-- Name: RI_ConstraintTrigger_3260299; Type: TRIGGER; Schema: public; Owner: tilfordc
--
CREATE CONSTRAINT TRIGGER "<unnamed>"
AFTER INSERT OR UPDATE ON mapping
FROM seqname
NOT DEFERRABLE INITIALLY IMMEDIATE
FOR EACH ROW
EXECUTE PROCEDURE "RI_FKey_check_ins" ('<unnamed>', 'mapping', 'seqname', 'UNSPECIFIED', 'name1', 'name_id');
--
-- TOC entry 68 (OID 3260300)
-- Name: RI_ConstraintTrigger_3260300; Type: TRIGGER; Schema: public; Owner: tilfordc
--
CREATE CONSTRAINT TRIGGER "<unnamed>"
AFTER DELETE ON seqname
FROM mapping
NOT DEFERRABLE INITIALLY IMMEDIATE
FOR EACH ROW
EXECUTE PROCEDURE "RI_FKey_noaction_del" ('<unnamed>', 'mapping', 'seqname', 'UNSPECIFIED', 'name1', 'name_id');
--
-- TOC entry 69 (OID 3260301)
-- Name: RI_ConstraintTrigger_3260301; Type: TRIGGER; Schema: public; Owner: tilfordc
--
CREATE CONSTRAINT TRIGGER "<unnamed>"
AFTER UPDATE ON seqname
FROM mapping
NOT DEFERRABLE INITIALLY IMMEDIATE
FOR EACH ROW
EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('<unnamed>', 'mapping', 'seqname', 'UNSPECIFIED', 'name1', 'name_id');
--
-- TOC entry 87 (OID 3260302)
-- Name: RI_ConstraintTrigger_3260302; Type: TRIGGER; Schema: public; Owner: tilfordc
--
CREATE CONSTRAINT TRIGGER "<unnamed>"
AFTER INSERT OR UPDATE ON mapping
FROM seqname
NOT DEFERRABLE INITIALLY IMMEDIATE
FOR EACH ROW
EXECUTE PROCEDURE "RI_FKey_check_ins" ('<unnamed>', 'mapping', 'seqname', 'UNSPECIFIED', 'name2', 'name_id');
--
-- TOC entry 70 (OID 3260303)
-- Name: RI_ConstraintTrigger_3260303; Type: TRIGGER; Schema: public; Owner: tilfordc
--
CREATE CONSTRAINT TRIGGER "<unnamed>"
AFTER DELETE ON seqname
FROM mapping
NOT DEFERRABLE INITIALLY IMMEDIATE
FOR EACH ROW
EXECUTE PROCEDURE "RI_FKey_noaction_del" ('<unnamed>', 'mapping', 'seqname', 'UNSPECIFIED', 'name2', 'name_id');
--
-- TOC entry 71 (OID 3260304)
-- Name: RI_ConstraintTrigger_3260304; Type: TRIGGER; Schema: public; Owner: tilfordc
--
CREATE CONSTRAINT TRIGGER "<unnamed>"
AFTER UPDATE ON seqname
FROM mapping
NOT DEFERRABLE INITIALLY IMMEDIATE
FOR EACH ROW
EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('<unnamed>', 'mapping', 'seqname', 'UNSPECIFIED', 'name2', 'name_id');
--
-- TOC entry 88 (OID 3260305)
-- Name: RI_ConstraintTrigger_3260305; Type: TRIGGER; Schema: public; Owner: tilfordc
--
CREATE CONSTRAINT TRIGGER "<unnamed>"
AFTER INSERT OR UPDATE ON mapping
FROM transform
NOT DEFERRABLE INITIALLY IMMEDIATE
FOR EACH ROW
EXECUTE PROCEDURE "RI_FKey_check_ins" ('<unnamed>', 'mapping', 'transform', 'UNSPECIFIED', 'trans_id', 'trans_id');
--
-- TOC entry 75 (OID 3260306)
-- Name: RI_ConstraintTrigger_3260306; Type: TRIGGER; Schema: public; Owner: tilfordc
--
CREATE CONSTRAINT TRIGGER "<unnamed>"
AFTER DELETE ON transform
FROM mapping
NOT DEFERRABLE INITIALLY IMMEDIATE
FOR EACH ROW
EXECUTE PROCEDURE "RI_FKey_noaction_del" ('<unnamed>', 'mapping', 'transform', 'UNSPECIFIED', 'trans_id',
'trans_id');
--
-- TOC entry 76 (OID 3260307)
-- Name: RI_ConstraintTrigger_3260307; Type: TRIGGER; Schema: public; Owner: tilfordc
--
CREATE CONSTRAINT TRIGGER "<unnamed>"
AFTER UPDATE ON transform
FROM mapping
NOT DEFERRABLE INITIALLY IMMEDIATE
FOR EACH ROW
EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('<unnamed>', 'mapping', 'transform', 'UNSPECIFIED', 'trans_id',
'trans_id');
--
-- TOC entry 89 (OID 3260308)
-- Name: RI_ConstraintTrigger_3260308; Type: TRIGGER; Schema: public; Owner: tilfordc
--
CREATE CONSTRAINT TRIGGER "<unnamed>"
AFTER INSERT OR UPDATE ON mapping
FROM authority
NOT DEFERRABLE INITIALLY IMMEDIATE
FOR EACH ROW
EXECUTE PROCEDURE "RI_FKey_check_ins" ('<unnamed>', 'mapping', 'authority', 'UNSPECIFIED', 'authority_id',
'authority_id');
--
-- TOC entry 48 (OID 3260309)
-- Name: RI_ConstraintTrigger_3260309; Type: TRIGGER; Schema: public; Owner: tilfordc
--
CREATE CONSTRAINT TRIGGER "<unnamed>"
AFTER DELETE ON authority
FROM mapping
NOT DEFERRABLE INITIALLY IMMEDIATE
FOR EACH ROW
EXECUTE PROCEDURE "RI_FKey_noaction_del" ('<unnamed>', 'mapping', 'authority', 'UNSPECIFIED', 'authority_id',
'authority_id');
--
-- TOC entry 49 (OID 3260310)
-- Name: RI_ConstraintTrigger_3260310; Type: TRIGGER; Schema: public; Owner: tilfordc
--
CREATE CONSTRAINT TRIGGER "<unnamed>"
AFTER UPDATE ON authority
FROM mapping
NOT DEFERRABLE INITIALLY IMMEDIATE
FOR EACH ROW
EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('<unnamed>', 'mapping', 'authority', 'UNSPECIFIED', 'authority_id',
'authority_id');
--
-- TOC entry 92 (OID 3260311)
-- Name: RI_ConstraintTrigger_3260311; Type: TRIGGER; Schema: public; Owner: tilfordc
--
CREATE CONSTRAINT TRIGGER "<unnamed>"
AFTER INSERT OR UPDATE ON "location"
FROM mapping
NOT DEFERRABLE INITIALLY IMMEDIATE
FOR EACH ROW
EXECUTE PROCEDURE "RI_FKey_check_ins" ('<unnamed>', 'location', 'mapping', 'UNSPECIFIED', 'map_id', 'map_id');
--
-- TOC entry 90 (OID 3260312)
-- Name: RI_ConstraintTrigger_3260312; Type: TRIGGER; Schema: public; Owner: tilfordc
--
CREATE CONSTRAINT TRIGGER "<unnamed>"
AFTER DELETE ON mapping
FROM "location"
NOT DEFERRABLE INITIALLY IMMEDIATE
FOR EACH ROW
EXECUTE PROCEDURE "RI_FKey_noaction_del" ('<unnamed>', 'location', 'mapping', 'UNSPECIFIED', 'map_id', 'map_id');
--
-- TOC entry 91 (OID 3260313)
-- Name: RI_ConstraintTrigger_3260313; Type: TRIGGER; Schema: public; Owner: tilfordc
--
CREATE CONSTRAINT TRIGGER "<unnamed>"
AFTER UPDATE ON mapping
FROM "location"
NOT DEFERRABLE INITIALLY IMMEDIATE
FOR EACH ROW
EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('<unnamed>', 'location', 'mapping', 'UNSPECIFIED', 'map_id', 'map_id');