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

From Benoît Bournon
Subject Re: [pg-sql] - Problem with duplicate table (PostgreSQL 7.2.3
Date
Msg-id 3F3740A3.4070404@adelis.com
Whole thread Raw
In response to Re: [pg-sql] - Problem with duplicate table (PostgreSQL 7.2.3  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
List pgsql-sql
No trigger <br /><br /> Just triggers for foreign key in spectacle and none in spectacle_v<br /><br /> How is it
possibleto verify triggers for foreign keys ? <br /><br /><br /><br /> Stephan Szabo a écrit:<br /><blockquote
cite="mid20030808085155.V71867-100000@megazone.bigpanda.com"type="cite"><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>

pgsql-sql by date:

Previous
From: proghome@silesky.com (krystoffff)
Date:
Subject: optimisation of a code
Next
From: Christopher Browne
Date:
Subject: Re: INSERT INTO ... SELECT