Re: [SQL] How to update dependent tables AND design considerations

2005-01-25 Thread Thomas F . O'Connell
Have you looked at the documentation on triggers? -tfo -- Thomas F. O'Connell Co-Founder, Information Architect Sitening, LLC http://www.sitening.com/ 110 30th Avenue North, Suite 6 Nashville, TN 37203-6320 615-260-0005 On Jan 23, 2005, at 11:23 AM, Klaus W. wrote: Hi! Because i got no answer in pg

[SQL] How to update dependent tables AND design considerations

2005-01-25 Thread Klaus W.
Hi! Because i got no answer in pgsql.novice, i'll try it here. But maybe it was even too easy for .novice? Lets say there are three tables: CREATE TABLE c (id SERIAL, data VARCHAR(20)); CREATE TABLE b (id SERIAL, c_id INTEGER REFERENCES c, data VARCHAR(20)); CREATE TABLE a (id SERIAL, b_id INTEG