Bug report - Mailing list pgsql-bugs

============================================================================
                        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');