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/
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) |