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