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 15:40:46 +0200
Message-ID: <3F379CDE.2000602@adelis.com> (raw)
In-Reply-To: <20030811061208.T72304-100000@megazone.bigpanda.com>
References: <20030811061208.T72304-100000@megazone.bigpanda.com>
we make a dump before ... and with a product pgmanager (ems tech) we do
not show any foreign keys.
But I think all of triggers of referenced table are not deleted.
We recreate the schemas ... and now is running.
How is it possible to identify Triggers with no referenced tables ?
Stephan Szabo a écrit:
>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?
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 6: Have you searched our list archives?
>
> http://archives.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: <3F379CDE.2000602@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