Skip site navigation (1) Skip section navigation (2)

RE: [DOC] Looking for foreign key and triggers doc

From: "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au>
To: "Jean-Francois Leveque" <leveque(at)webmails(dot)com>, <pgsql-docs(at)postgresql(dot)org>
Subject: RE: [DOC] Looking for foreign key and triggers doc
Date: 2001-06-07 02:08:41
Message-ID: ECEHIKNFIMMECLEBJFIGOEOMCAAA.chriskl@familyhealth.com.au (view raw or flat)
Thread:
Lists: pgsql-docs
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(at)postgresql(dot)org
> [mailto:pgsql-docs-owner(at)postgresql(dot)org]On Behalf Of Jean-Francois
> Leveque
> 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 GollopDate: 2001-06-07 09:46:52
Subject: documentation
Previous:From: Jean-Francois LevequeDate: 2001-06-06 12:15:15
Subject: [DOC] Looking for foreign key and triggers doc

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group