Postgres Pro
Downloads
Home   >   mailing lists

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

From Stephan Szabo
Subject Re: [pg-sql] - Problem with duplicate table (PostgreSQL 7.2.3
Date
Msg-id 20030808085155.V71867-100000@megazone.bigpanda.com
Whole thread Raw
In response to [pg-sql] - Problem with duplicate table (PostgreSQL 7.2.3  (BenLaKnet <benlaknet@icqmail.com>)
Responses Re: [pg-sql] - Problem with duplicate table (PostgreSQL 7.2.3  (BenLaKnet <benlaknet@icqmail.com>)
Re: [pg-sql] - Problem with duplicate table (PostgreSQL 7.2.3  (Benoît Bournon <benoit.bournon@adelis.com>)
List pgsql-sql
Tree view 
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?

pgsql-sql by date:

Previous
From: Jonathan Gardner
Date:
Subject: Re: duplicate dates
Next
From: Jonathan Gardner
Date:
Subject: Re: converting interval to timestamp