Re: [SQL] Looking for some help with cascading updates...

2006-04-18 Thread Mark True
Next silly question, how do you get your database to like plpgsql...I do CREATE LANGUAGE 'plpgsql' and it says it is not defined?--MarkOn 4/18/06, Andreas Kretschmer <[EMAIL PROTECTED]> wrote: Mark True <[EMAIL PROTECTED]> schrieb:> I guess I should have clarified.  I a

Re: [SQL] Looking for some help with cascading updates...

2006-04-18 Thread Mark True
wrote: Mark True <[EMAIL PROTECTED]> schrieb: >> 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, Add

[SQL] Looking for some help with cascading updates...

2006-04-18 Thread Mark True
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 levelINSERT INTO myTable (Name, Address, Zip) VALUES ('Mark', '3 Dingle St.', '01832') myTable has a relation to two other tables,