X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id BF3A256443;
	Mon,  7 Mar 2005 15:32:11 +0000 (GMT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 94942-04; Mon,  7 Mar 2005 15:32:09 +0000 (GMT)
Received: from ucsns.ucs.co.za (ucs.co.za [196.23.43.2])
	by svr1.postgresql.org (Postfix) with ESMTP id A1272563D1;
	Mon,  7 Mar 2005 15:31:57 +0000 (GMT)
Received: from ucspost.ucs.co.za (mailgw1.ucs.co.za [196.23.43.253])
	by ucsns.ucs.co.za (Postfix) with ESMTP id 9E18A2BD47;
	Mon,  7 Mar 2005 17:31:55 +0200 (SAST)
Received: from jhb.ucs.co.za (jhb.ucs.co.za [172.31.1.3])
	by ucspost.ucs.co.za (Postfix) with ESMTP
	id 77B83D9F3D; Mon,  7 Mar 2005 17:31:54 +0200 (SAST)
Received: from svb.ucs.co.za (svb.ucs.co.za [172.31.1.148])
	by jhb.ucs.co.za (Postfix) with ESMTP id 0256597AEB;
	Mon,  7 Mar 2005 17:31:55 +0200 (SAST)
Date: Mon, 7 Mar 2005 17:31:55 +0200
From: Stef <svb@ucs.co.za>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-ADMIN@postgresql.org, pgsql-sql@postgresql.org
Subject: Re: [SQL] Postgres schema comparison.
Message-ID: <20050307173155.285dc2eb@svb.ucs.co.za>
In-Reply-To: <22961.1110205853@sss.pgh.pa.us>
References: <20050307113312.2200b65c@svb.ucs.co.za>
	<422C42B7.1030509@logix-tt.com>
	<20050307145444.459e54fe@svb.ucs.co.za>
	<22961.1110205853@sss.pgh.pa.us>
X-Mailer: Sylpheed-Claws 1.0.1 (GTK+ 1.2.10; i386-pc-linux-gnu)
User-Agent: sillypheed-claws (anti-aliased)
X-Face: +lU/o'$=Zv9%Xjo]Kq[_{n&Kb`f{YE<S+T;
	pGztI>WH4&Y#M]'6BkD?VoWe#*@S\MWyD'I>s:0v4{#\[J]l*?]t2uaO(j$d*77Ca-UHo.tkl2)0$B3Jxww\o:xor]<:*Yfx9Vceh)9I/'2g\RKhGTxIIsR^ke^`LVeZ9ksb*:$kQeR@
X-Operating-System: sid
X-X-X: _-^-_
Mime-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.341 tagged_above=0 required=5 tests=AWL,
	DNS_FROM_RFC_WHOIS
X-Spam-Level: 
X-Archive-Number: 200503/91
X-Sequence-Number: 16589

Tom Lane mentioned :
=> > The problem I have with this, is that I have to run the command per table,
=> 
=> Why?
=> 
=> If the problem is varying order of table declarations, try 8.0's
=> pg_dump.

Yes, this will solve the global schema check, but I will still need to split
it into "per table" dumps , to do "per table" comparisons.

Kind Regards
Stefan