X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [64.117.224.130])
	by svr1.postgresql.org (Postfix) with ESMTP id 8A7ADD1C4DB
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Fri,  8 Aug 2003 15:52:42 +0000 (GMT)
Received: from svr1.postgresql.org ([64.117.224.193])
	by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new,
	port 10024) with ESMTP id 44516-04
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Fri,  8 Aug 2003 12:51:14 -0300 (ADT)
Received: from megazone.bigpanda.com (45.mufb.snfc.sffca01r18.dsl.att.net
	[12.103.249.45])
	by svr1.postgresql.org (Postfix) with ESMTP id 5911AD1C4B9
	for <pgsql-sql@postgresql.org>; Fri,  8 Aug 2003 12:52:31 -0300 (ADT)
Received: by megazone.bigpanda.com (Postfix, from userid 1001)
	id D1D13D622; Fri,  8 Aug 2003 08:52:30 -0700 (PDT)
Received: from localhost (localhost [127.0.0.1])
	by megazone.bigpanda.com (Postfix) with ESMTP
	id C77885C0A; Fri,  8 Aug 2003 08:52:30 -0700 (PDT)
Date: Fri, 8 Aug 2003 08:52:30 -0700 (PDT)
From: Stephan Szabo <sszabo@megazone.bigpanda.com>
To: BenLaKnet <benlaknet@icqmail.com>
Cc: <pgsql-sql@postgresql.org>
Subject: Re: [pg-sql] - Problem with duplicate table (PostgreSQL 7.2.3
In-Reply-To: <3F335BC7.7070800@icqmail.com>
Message-ID: <20030808085155.V71867-100000@megazone.bigpanda.com>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200308/71
X-Sequence-Number: 14687

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?