[DOC] Looking for foreign key and triggers doc
[DOC] Looking for foreign key and triggers doc
От:
"Jean-Francois Leveque" <leveque@webmails.com>
Дата:
When I create a foreign key, I got weird triggers created (I'm getting info on it from a pg_dump ouput). I'm not sure if it's a bug or a correct feature. I'm looking for documentation to be sure. I would like to know where I can get information about pg_trigger and getting human-readable information out of it. I would also like to know in detail what triggers are supposed to be created when you create a foreign key. Best Regards, Jean-Francois Leveque ______________________________________________________________________ Sur WebMailS.com, mon adresse de courrier �lectronique gratuite. Service multilingue, s�r, et permanent. http://www.webmails.com/
RE: [DOC] Looking for foreign key and triggers doc
От:
"Christopher Kings-Lynne" <chriskl@familyhealth.com.au>
Дата:
Hi Jean-Francois, When you create a foreign key, three triggers are created. One to check inserts/updates in the child table and one to check deletes on the parent table. Read this: http://techdocs.postgresql.org/techdocs/hackingreferentialintegrity.php To learn more about the behind-the-scenes RI in PostgreSQL. Chris > -----Original Message----- > From: pgsql-docs-owner@postgresql.org > [mailto:pgsql-docs-owner@postgresql.org]On Behalf Of Jean-Francois > Leveque > Sent: Wednesday, 6 June 2001 8:15 PM > To: pgsql-docs@postgresql.org > Subject: [DOCS] [DOC] Looking for foreign key and triggers doc > > > > When I create a foreign key, I got weird triggers > created (I'm getting info on it from a pg_dump ouput). > I'm not sure if it's a bug or a correct feature. > I'm looking for documentation to be sure. > > I would like to know where I can get information > about pg_trigger and getting human-readable information > out of it. > > I would also like to know in detail what triggers are > supposed to be created when you create a foreign key. > > > Best Regards, > > Jean-Francois Leveque > > > ______________________________________________________________________ > Sur WebMailS.com, mon adresse de courrier électronique gratuite. > Service multilingue, sûr, et permanent. http://www.webmails.com/ > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org) >