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
To learn more about the behind-the-scenes RI in PostgreSQL.
> -----Original Message-----
> From: pgsql-docs-owner(at)postgresql(dot)org
> [mailto:pgsql-docs-owner(at)postgresql(dot)org]On Behalf Of Jean-Francois
> Sent: Wednesday, 6 June 2001 8:15 PM
> To: pgsql-docs(at)postgresql(dot)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(at)postgresql(dot)org)
In response to
pgsql-docs by date
|Next:||From: Julian Gollop||Date: 2001-06-07 09:46:52|
|Previous:||From: Jean-Francois Leveque||Date: 2001-06-06 12:15:15|
|Subject: [DOC] Looking for foreign key and triggers doc|