From: Benoît Bournon <benoit.bournon@adelis.com>
To: Stephan Szabo <sszabo@megazone.bigpanda.com>
Cc: BenLaKnet <benlaknet@icqmail.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: [pg-sql] - Problem with duplicate table (PostgreSQL 7.2.3
Date: Mon, 11 Aug 2003 09:07:15 +0200
Message-ID: <3F3740A3.4070404@adelis.com> (raw)
In-Reply-To: <20030808085155.V71867-100000@megazone.bigpanda.com>
References: <20030808085155.V71867-100000@megazone.bigpanda.com>
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)
>
>
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: benoit.bournon@adelis.com, sszabo@megazone.bigpanda.com, benlaknet@icqmail.com
Subject: Re: [pg-sql] - Problem with duplicate table (PostgreSQL 7.2.3
In-Reply-To: <3F3740A3.4070404@adelis.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox