All,
I have inherited a table (below) with a RI trigger.
I believe this table was created where both clone_id & blastx_id are FKs
w/ stipulation 'ON DELETE CASCADE'.
My question is, is this specified in the trigger:
RI_ConstraintTrigger_11264756?
If so how would I learn the content of the trigger knowing just the
trigger id (11264756)?
I have not seen a 'decoding' of triggers using pgsql.
regards,
Charles
CREATE TABLE clone_blastx(
clone_id INTEGER NOT NULL REFERENCES clone(clone_id) ON DELETE CASCADE,
blastx_id INTEGER NOT NULL REFERENCES blastx(blastx_id) ON DELETE CASCADE,
UNIQUE(clone_id,blastx_id)
);
Column | Type | Modifiers
-----------+---------+-----------
clone_id | integer |
contig_id | integer |
Indexes: clone_contig_clone_id_key unique btree (clone_id, contig_id),
clone_id_clone_contig_key btree (clone_id),
contig_id_clone_contig_key btree (contig_id)
Triggers: RI_ConstraintTrigger_11264756
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
