Re: [pg-sql] - Problem with duplicate table (PostgreSQL 7.2.3

From: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
To: BenLaKnet <benlaknet(at)icqmail(dot)com>
Cc: <pgsql-sql(at)postgresql(dot)org>
Subject: Re: [pg-sql] - Problem with duplicate table (PostgreSQL 7.2.3
Date: 2003-08-08 15:52:30
Message-ID: 20030808085155.V71867-100000@megazone.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Fri, 8 Aug 2003, BenLaKnet wrote:

> When I duplicate this code in an other table named spectacle_v without
> Foreygn key ... all is running.
>
> But when I try to delete a spectacle_membre, linked value in spectacle
> are correctly deleted, but I have an error for spectacle_v which is not
> linked :
>
> (ERROR: referential integrity violation - key in membre_adherent still
> referenced from spectacle_v )

What triggers are defined on membre_adherent?

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Jonathan Gardner 2003-08-08 16:22:01 Re: converting interval to timestamp
Previous Message Jonathan Gardner 2003-08-08 15:29:36 Re: duplicate dates