From: Mark True <darfoo@gmail.com>
To: pgsql-sql@postgresql.org
Subject: Looking for some help with cascading updates...
Date: Tue, 18 Apr 2006 14:19:20 -0400
Message-ID: <647d31c20604181119m43ba3c7ay3d467dd9446a6fd8@mail.gmail.com> (raw)
Here is the question:
I have a situation where I need to create triggers to cascade an insert
operation to many tables to maintain foreign key constraints.
So at a high level
INSERT INTO myTable (Name, Address, Zip) VALUES ('Mark', '3 Dingle St.',
'01832')
myTable has a relation to two other tables, which contain Zip and Address.
Before I insert into myTable I want to:
Check if '3 Dingle St.' exists in table Address, if not insert it
Check if '01832' exists in table Zip and if not insert it
I want to generalize this so that for any insert into myTable, I guarantee
that if Zip and Address are not populated they will be. My insert into
myTable always contains full information required for doing the inserts into
the other related tables.
Help?
--Mark
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: darfoo@gmail.com
Subject: Re: Looking for some help with cascading updates...
In-Reply-To: <647d31c20604181119m43ba3c7ay3d467dd9446a6fd8@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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