Need information about Foreign Key created Triggers

From: "Jean-Francois Leveque" <leveque(at)webmails(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Need information about Foreign Key created Triggers
Date: 2001-06-08 13:21:56
Message-ID: 20010608152157.2008.qmail@webmails.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


I created a Foreign Key (REFERENCES) constraint on
a table like this (some columns ommited) :
CREATE TABLE tablename (
id_tablename INTEGER DEFAULT nextval('id_tablename_seq'),
tablename_parent INTEGER CONSTRAINT tablename_parent_fk
REFERENCES tablename (id_tablename),
CONSTRAINT tablename_pk PRIMARY KEY (id_tablename)
);

When I pg_dump, I can see three triggers :
The first calls RI_FKey_check_ins AFTER INSERT OR UPDATE,
the second one calls RI_FKey_noaction_del AFTER DELETE,
the third one calls RI_FKey_noaction_upd AFTER UPDATE.

All the triggers and procedure calls have the same parameters.

I browsed the docs, looked at :
http://techdocs.postgresql.org/techdocs/hackingreferentialintegrity.php

and asked pgsql-docs but I couldn't find what they
really do. Can someone give me information about
those Triggers created for FKey RI ?

Best Regards,

Jean-Francois Leveque

______________________________________________________________________
Sur WebMailS.com, mon adresse de courrier lectronique gratuite.
Service multilingue, sr, et permanent. http://www.webmails.com/

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2001-06-08 14:17:05 Re: AW: Re: [SQL] behavior of ' = NULL' vs. MySQL vs. Stand ards
Previous Message D'Arcy J.M. Cain 2001-06-08 13:07:05 ERROR: Memory exhausted in AllocSetAlloc(909324558)