Re: ON DELETE CASCADE doesn't work

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: Miia Leino <miia(dot)leino(at)zeerio(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: ON DELETE CASCADE doesn't work
Date: 2002-04-16 18:53:39
Message-ID: 20020416115210.J49584-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


On Tue, 16 Apr 2002, Miia Leino wrote:

> I'm having a problem with automatic deletion from the referencing
> table when a row is deletet from the parent table. This works
> sometimes and sometimes it doesn't, could someone have an idea why
> this is happening??

Can you give a full script with the inserts and deletes necessary to
replicate? Also, what version are you using? When it doesn't work
does it give an error or does it just not delete the row?

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Michael Loftis 2002-04-16 18:57:20 Re: function for creating random id
Previous Message Marin Dimitrov 2002-04-16 18:37:38 Re: user question about log