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 B8213D1C4E3
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Mon, 11 Aug 2003 07:23:16 +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 61206-03
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Mon, 11 Aug 2003 04:21:48 -0300 (ADT)
Received: from neptune.adelis.net (neptune.adelis.net [195.115.171.102])
	by svr1.postgresql.org (Postfix) with ESMTP id 56871D1C4D6
	for <pgsql-sql@postgresql.org>; Mon, 11 Aug 2003 04:23:05 -0300 (ADT)
Received: from icqmail.com (ben.adelis.net [195.115.171.16])
	by neptune.adelis.net (Postfix) with ESMTP
	id 8EAE57918B; Mon, 11 Aug 2003 09:14:50 +0200 (CEST)
Message-ID: <3F374458.3000207@icqmail.com>
Date: Mon, 11 Aug 2003 09:23:04 +0200
From: BenLaKnet <benlaknet@icqmail.com>
User-Agent: Mozilla/5.0 (X11; U; Linux i686; fr-FR; rv:1.2.1) Gecko/20030225
X-Accept-Language: fr, en-us, en, ja
MIME-Version: 1.0
To: Stephan Szabo <sszabo@megazone.bigpanda.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: [pg-sql] - Problem with duplicate table (PostgreSQL 7.2.3
References: <20030808085155.V71867-100000@megazone.bigpanda.com>
In-Reply-To: <20030808085155.V71867-100000@megazone.bigpanda.com>
Content-Type: multipart/alternative;
	boundary="------------010206010303070000030107"
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200308/92
X-Sequence-Number: 14708

--------------010206010303070000030107
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit

No trigger

Just triggers for foreign key in spectacle and none in spectacle_v

How is it possible to verify triggers for foreign keys ?



Stephan Szabo a écrit:

>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?
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 2: you can get off all lists at once with the unregister command
>    (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>
>  
>

--------------010206010303070000030107
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
  <title></title>
</head>
<body>
No trigger <br>
<br>
Just triggers for foreign key in spectacle and none in spectacle_v<br>
<br>
How is it possible to verify triggers for foreign keys ? <br>
<br>
<br>
<br>
Stephan Szabo a &eacute;crit:<br>
<blockquote type="cite"
 cite="mid20030808085155.V71867-100000@megazone.bigpanda.com">
  <pre wrap="">On Fri, 8 Aug 2003, BenLaKnet wrote:

  </pre>
  <blockquote type="cite">
    <pre wrap="">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 )
    </pre>
  </blockquote>
  <pre wrap=""><!---->
What triggers are defined on membre_adherent?


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to <a class="moz-txt-link-abbreviated" href="mailto:majordomo@postgresql.org">majordomo@postgresql.org</a>)

  </pre>
</blockquote>
</body>
</html>

--------------010206010303070000030107--