Deleting Problem

From: Jamie Deppeler <jamie(at)doitonce(dot)net(dot)au>
To: General PostgreSQL List <pgsql-general(at)postgresql(dot)org>
Subject: Deleting Problem
Date: 2006-10-30 23:24:02
Message-ID: 45468992.4090305@doitonce.net.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Here is my problem

I have a level structure which is 5 levels deep with 6 tables, for this
example i will call it table1,table2,table3,table4,table5,table6

(1)table1
(2)table2
(3)table3
(4)table4
(5)table5,table6
(6)table7,table8

table5 and table6 have fk keys pointing to table1,table2,table3,table4.
table7 and table 8 have fk keys pointing to table5.

Here is my problem i have delete triggers on table5 and table6 which
update summary information on table1,table2,table3,table4 if table5 or 6
gets delete, problem i am faced with is when eg table1 record gets
deleted i get the following error Error insert or update on table5
violates foreign key constraint "table4". They are all link with a
cascade delete.

Machine Windows 2003, Postgresql 8.1.4

Any help would be useful.

Thank you.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Brent Wood 2006-10-30 23:24:21 Re: PostGIS
Previous Message ecolgan 2006-10-30 19:46:01 Timeout Value on network error