Looking for some help with cascading updates...
От
Mark True
Тема
Looking for some help with cascading updates...
Дата
Msg-id
647d31c20604181119m43ba3c7ay3d467dd9446a6fd8@mail.gmail.com
Список
Дерево обсуждения
Looking for some help with cascading updates... "Mark True" <darfoo@gmail.com>
Re: Looking for some help with cascading updates... Andreas Kretschmer <akretschmer@spamfence.net>
Re: Looking for some help with cascading updates... "Mark True" <darfoo@gmail.com>
Re: Looking for some help with cascading updates... Andreas Kretschmer <akretschmer@spamfence.net>
Re: Looking for some help with cascading updates... "Mark True" <darfoo@gmail.com>
Re: Looking for some help with cascading updates... Tom Lane <tgl@sss.pgh.pa.us>
Re: Looking for some help with cascading updates... Andreas Kretschmer <akretschmer@spamfence.net>
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
В списке pgsql-sql по дате отправления