Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id C61B86333B4; Tue, 23 Feb 2010 00:50:40 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 08038-06-4; Tue, 23 Feb 2010 04:50:30 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-wy0-f174.google.com (mail-wy0-f174.google.com [74.125.82.174]) by mail.postgresql.org (Postfix) with ESMTP id 22416632EC5; Tue, 23 Feb 2010 00:50:28 -0400 (AST) Received: by wya21 with SMTP id 21so449534wya.19 for ; Mon, 22 Feb 2010 20:50:27 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:date:message-id:subject :from:to:content-type; bh=DiBuQx6pVtAJHcs3AqBzY0Ay1DvuNpkHWNNcKby7kPc=; b=CV3W9hvS+HitNB4SBUvFCRmzXrqBfSv/Auqrww5kP4dQ/34m91IpLAq3UP45yiRNnP 7QYiu58zDZ2rbdbB2GgliFvlOZHINZGbMzern/stQV3DyxbHH0T+U4fvfFpYJxv1rixO ThMI60UqV/pIJdxJKzzHaN+W9Uz5/XOoKCsag= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:date:message-id:subject:from:to:content-type; b=jB3oo4vS/1lCTYeEBQPD55tiEGcgMspDrGiuAzOx6Sh8ZKqt3agFpoMnpn8O5N6vYn 1Mak6Ib6K5GmYZem/iQ7dnK5Ku+BzQWmXImo4y5q0biINjBphOKq5C5vrxkvvNnVNB6C d+bxiUY9YO5qdNjnE/9IYiar5CS/QXOAJ5DCc= MIME-Version: 1.0 Received: by 10.216.88.71 with SMTP id z49mr192208wee.90.1266900627830; Mon, 22 Feb 2010 20:50:27 -0800 (PST) Date: Tue, 23 Feb 2010 12:50:27 +0800 Message-ID: Subject: how do I do dump and restore without bugging with constraint? From: "Net Tree Inc." To: pgsql-admin@postgresql.org, pgsql-general@postgresql.org Content-Type: multipart/alternative; boundary=0016e6dab0ece338fa04803d495b X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.002 tagged_above=-10 required=5 tests=BAYES_50=0.001, HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 201002/169 X-Sequence-Number: 33772 --0016e6dab0ece338fa04803d495b Content-Type: text/plain; charset=ISO-8859-1 Hi all, I am dumping both schema and data from old database to new one. The new database schema is somehow contain slightly different schema then the old one. When I do restore it shown alot errors related with constraints. How can I dump and to restore from old to new without dealing with constraint and just forces data dump to where it suppose to belong? --0016e6dab0ece338fa04803d495b Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Hi all,

I am dumping both schema and data from old datab= ase to new one. The new database schema is somehow contain slightly differe= nt schema then the old one. When I do restore it shown alot errors related = with constraints. How can I dump and to restore from old to new without dea= ling with constraint and just forces data dump to where it suppose to belon= g?=A0




--0016e6dab0ece338fa04803d495b--