X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [64.117.224.130])
	by svr1.postgresql.org (Postfix) with ESMTP id 6982CD1C4D6
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Mon, 11 Aug 2003 13:40:51 +0000 (GMT)
Received: from svr1.postgresql.org ([64.117.224.193])
	by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new,
	port 10024) with ESMTP id 89563-07
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Mon, 11 Aug 2003 10:39:25 -0300 (ADT)
Received: from neptune.adelis.net (neptune.adelis.net [195.115.171.102])
	by svr1.postgresql.org (Postfix) with ESMTP id 8053CD1C4B9
	for <pgsql-sql@postgresql.org>; Mon, 11 Aug 2003 10:40:40 -0300 (ADT)
Received: from adelis.com (ben.adelis.net [195.115.171.16])
	by neptune.adelis.net (Postfix) with ESMTP
	id 8EA687918B; Mon, 11 Aug 2003 15:32:29 +0200 (CEST)
Message-ID: <3F379CDE.2000602@adelis.com>
Date: Mon, 11 Aug 2003 15:40:46 +0200
From: =?ISO-8859-1?Q?Beno=EEt_Bournon?= <benoit.bournon@adelis.com>
User-Agent: Mozilla/5.0 (X11; U; Linux i686; fr-FR; rv:1.2.1) Gecko/20030225
X-Accept-Language: fr, en-us, en, ja
MIME-Version: 1.0
To: Stephan Szabo <sszabo@megazone.bigpanda.com>
Cc: BenLaKnet <benlaknet@icqmail.com>, pgsql-sql@postgresql.org
Subject: Re: [pg-sql] - Problem with duplicate table (PostgreSQL 7.2.3
References: <20030811061208.T72304-100000@megazone.bigpanda.com>
In-Reply-To: <20030811061208.T72304-100000@megazone.bigpanda.com>
Content-Type: multipart/alternative;
	boundary="------------000103000704070101040508"
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200308/111
X-Sequence-Number: 14727

--------------000103000704070101040508
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit

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
>
>  
>

--------------000103000704070101040508
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
  <title></title>
</head>
<body>
we make a dump before ... and with a product pgmanager (ems tech) we do
not show any foreign keys.<br>
<br>
But I think all of triggers of referenced table are not deleted.<br>
<br>
We recreate the schemas ... and now is running.<br>
<br>
How is it possible to identify Triggers with no referenced tables ?<br>
<br>
<br>
Stephan Szabo a &eacute;crit:<br>
<blockquote type="cite"
 cite="mid20030811061208.T72304-100000@megazone.bigpanda.com">
  <pre wrap="">On Mon, 11 Aug 2003, [ISO-8859-1] Beno?t Bournon wrote:

  </pre>
  <blockquote type="cite">
    <pre wrap="">No trigger

Just triggers for foreign key in spectacle and none in spectacle_v

How is it possible to verify triggers for foreign keys ?
    </pre>
  </blockquote>
  <pre wrap=""><!---->
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?

               <a class="moz-txt-link-freetext" href="http://archives.postgresql.org">http://archives.postgresql.org</a>

  </pre>
</blockquote>
</body>
</html>

--------------000103000704070101040508--