pg.ddx.io pgsql-docs@postgresql.org mailing list archive
help / color / mirror / Atom feed[DOC] Looking for foreign key and triggers doc
2+ messages / 2 participants
[nested] [flat]
* [DOC] Looking for foreign key and triggers doc
@ 2001-06-06 12:15 Jean-Francois Leveque <leveque@webmails.com>
0 siblings, 1 reply; 2+ messages in thread
From: Jean-Francois Leveque @ 2001-06-06 12:15 UTC (permalink / raw)
To: pgsql-docs
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/
^ permalink raw reply [nested|flat] 2+ messages in thread
* RE: [DOC] Looking for foreign key and triggers doc
@ 2001-06-07 02:08 Christopher Kings-Lynne <chriskl@familyhealth.com.au>
parent: Jean-Francois Leveque <leveque@webmails.com>
0 siblings, 0 replies; 2+ messages in thread
From: Christopher Kings-Lynne @ 2001-06-07 02:08 UTC (permalink / raw)
To: Jean-Francois Leveque <leveque@webmails.com>; 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@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)
>
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2001-06-07 02:08 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-06-06 12:15 [DOC] Looking for foreign key and triggers doc Jean-Francois Leveque <leveque@webmails.com>
2001-06-07 02:08 ` Christopher Kings-Lynne <chriskl@familyhealth.com.au>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox