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 4742FD1C516
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Mon, 11 Aug 2003 13:44:12 +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 98689-03
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Mon, 11 Aug 2003 10:42:46 -0300 (ADT)
Received: from neptune.adelis.net (neptune.adelis.net [195.115.171.102])
	by svr1.postgresql.org (Postfix) with ESMTP id 042C5D1C510
	for <pgsql-sql@postgresql.org>; Mon, 11 Aug 2003 10:44:01 -0300 (ADT)
Received: from icqmail.com (ben.adelis.net [195.115.171.16])
	by neptune.adelis.net (Postfix) with ESMTP
	id 0709479185; Mon, 11 Aug 2003 15:35:51 +0200 (CEST)
Message-ID: <3F379DA8.7040501@icqmail.com>
Date: Mon, 11 Aug 2003 15:44:08 +0200
From: BenLaKnet <benlaknet@icqmail.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>,
	pgsql-sql@postgresql.org
Subject: Re: [pg-sql] - Problem with duplicate table (PostgreSQL 7.2.3
References: <20030811063822.W72304-100000@megazone.bigpanda.com>
In-Reply-To: <20030811063822.W72304-100000@megazone.bigpanda.com>
Content-Type: multipart/alternative;
	boundary="------------080609000009040301020103"
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200308/100
X-Sequence-Number: 14716

--------------080609000009040301020103
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 it's running.

How is it possible to identify Triggers with no referenced tables ?




Stephan Szabo a écrit:

>On Mon, 11 Aug 2003, BenLaKnet wrote:
>
>  
>
>>How could I do a pg_dump -s ??
>>
>>on local server ??
>>    
>>
>
>Yes.  I figured you wouldn't want to send your backups with data (I assume
>you have pg_dump generated backups ;) ).
>
>You can use pg_dump locally or remotely (using -h and -p options).
>Locally, log in as the postgres user and run pg_dump -s <databasename>,
>remotely do
>pg_dump -s -h <databasehost> -p <databaseport> <databasename>
>I believe.
>
>  
>

--------------080609000009040301020103
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 it's running.<br>
<br>
How is it possible to identify Triggers with no referenced tables ?<br>
<br>
<br>
<br>
<br>
Stephan Szabo a &eacute;crit:<br>
<blockquote type="cite"
 cite="mid20030811063822.W72304-100000@megazone.bigpanda.com">
  <pre wrap="">On Mon, 11 Aug 2003, BenLaKnet wrote:

  </pre>
  <blockquote type="cite">
    <pre wrap="">How could I do a pg_dump -s ??

on local server ??
    </pre>
  </blockquote>
  <pre wrap=""><!---->
Yes.  I figured you wouldn't want to send your backups with data (I assume
you have pg_dump generated backups ;) ).

You can use pg_dump locally or remotely (using -h and -p options).
Locally, log in as the postgres user and run pg_dump -s &lt;databasename&gt;,
remotely do
pg_dump -s -h &lt;databasehost&gt; -p &lt;databaseport&gt; &lt;databasename&gt;
I believe.

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

--------------080609000009040301020103--