Need information about Foreign Key created Triggers
| От | Jean-Francois Leveque |
|---|---|
| Тема | Need information about Foreign Key created Triggers |
| Дата | |
| Msg-id | 20010608152157.2008.qmail@webmails.com обсуждение исходный текст |
| Ответы |
Re: Need information about Foreign Key created Triggers
|
| Список | 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
CONSTRAINTtablename_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, s�r, et permanent. http://www.webmails.com/
В списке pgsql-hackers по дате отправления: