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 20030811061208.T72304-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  (Benoît Bournon <benoit.bournon@adelis.com>)
List pgsql-sql
On Mon, 11 Aug 2003, [ISO-8859-1] Beno�t Bournon wrote:

> No trigger
>
> Just triggers for foreign key in spectacle and none in spectacle_v
>
> How is it possible to verify triggers for foreign keys ?

Generally a select on pg_trigger.  Each foreign key should have 3
triggers, 1 on the referencing table and 2 on the referenced. You find the
tables involved by crossreferencing tgrelid against the oid of the row
in pg_class.

Can you send the results of a pg_dump -s?



pgsql-sql by date:

Previous
From: "Eric Anderson Vianet SAO"
Date:
Subject: update system table?
Next
From: Stephan Szabo
Date:
Subject: Re: sub-sel/group problem