X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 389B111F6AD4 for ; Thu, 27 Apr 2006 07:59:29 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 90835-09 for ; Thu, 27 Apr 2006 07:59:21 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from nproxy.gmail.com (nproxy.gmail.com [64.233.182.189]) by postgresql.org (Postfix) with ESMTP id 4491D11F6AD2 for ; Thu, 27 Apr 2006 07:59:18 -0300 (ADT) Received: by nproxy.gmail.com with SMTP id b2so821577nfe for ; Thu, 27 Apr 2006 03:59:19 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:mime-version:content-type; b=LcRGWzPgUjPKqeyd9clAMiq9ikrAg0tEbO99JP3u2Q6O6IR+l78sees6f87bK+uxRUbK7O4ZqnVTfKfP7BX04Vnet/xZthSEr9uBku6qsHzTFdHtu/CqT1IHNdhZvoAh6Xrimqm3+uMdFw77RMICH9CJwT2qhda07vFk29TwlEE= Received: by 10.48.217.13 with SMTP id p13mr3084855nfg; Thu, 27 Apr 2006 03:59:19 -0700 (PDT) Received: by 10.48.216.14 with HTTP; Thu, 27 Apr 2006 03:59:19 -0700 (PDT) Message-ID: <52543fce0604270359u7b2bac2cgd1e4cb93245bd245@mail.gmail.com> Date: Thu, 27 Apr 2006 12:59:19 +0200 From: "David Levy" To: pgsql-admin@postgresql.org Subject: pg_restore index/trigger restoration issue MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_24419_20410814.1146135559087" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200604/299 X-Sequence-Number: 21468 ------=_Part_24419_20410814.1146135559087 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: base64 Content-Disposition: inline SGksCgpJIGFtIGhhdmluZyB0cm91YmxlcyB1c2luZyBwZ19yZXN0b3JlIDogbm9uZSBvZiBteSBp bmRleGVzIGFyZSByZXN0b3JlZCAhCkl0IGRpZCBub3Qgc2VlIGFueSByZWxldmFudCBtZXNzYWdl IGluIHRoZSBwZ19yZXN0b3JlIG91dHB1dCB0byBleHBsYWluIHRoaXMKYmVoYXZpb3VyLgoKU28g SSBhbSB0cnlpbmcgdG8gcmVzdG9yZSBhIHBnX2R1bXAgKHZlcnNpb244LjEpIHNxbCBkdW1wIGZp bGUgZnJvbSBhIHJlbW90ZQo4LjAuMyBEQiBpbnRvIGEgbG9jYWwgOC4xIERCIHVzaW5nIHBnX3Jl c3RvcmUgKHZlcnNpb24gOC4xKS4KSXMgdGhlcmUgc29tZXRoaW5nIGluY29tcGF0aWJsZSA/ClRo ZSBkdW1wIGZpbGUgc2VlbXMgdG8gYmUgY29ycmVjdCByZWdhcmRpbmcgaW5kZXggY3JlYXRpb24g c3RhdGVtZW50cy4uLiBJCnJlYWxseSBkb24ndCB1bmRlcnN0YW5kIHdoYXQgaXMgaGFwcGVuaW5n LgoKQXMgdGhlIHRpdGxlIG1lbnRpb25zLCBJIGhhdmUgdGhlIHNhbWUgaXNzdWUgd2l0aCB0cmln Z2VycyA6IG5vbmUgb2YgbXkKdHJpZ2dlcnMgYXJlIHJlc3RvcmVkIG5laXRoZXIgISBJcyB0aGVy ZSBhbnkgb3B0aW9uIGluIHBnX2R1bXAgb3IgcGdfcmVzdG9yZQp0byBoYW5kbGUgdGhpcyA/CgoK UmVnYXJkcwoKVGhhbmtzIGluIGFkdmFuY2UKRGF2aWQgTEVWWQo= ------=_Part_24419_20410814.1146135559087 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: base64 Content-Disposition: inline SGksIDxicj48YnI+SSBhbSBoYXZpbmcgdHJvdWJsZXMgdXNpbmcgcGdfcmVzdG9yZSA6IG5vbmUg b2YgbXkgaW5kZXhlcyBhcmUgcmVzdG9yZWQgITxicj5JdCBkaWQgbm90IHNlZSBhbnkgcmVsZXZh bnQgbWVzc2FnZSBpbiB0aGUgcGdfcmVzdG9yZSBvdXRwdXQgdG8gZXhwbGFpbiB0aGlzIGJlaGF2 aW91ci48YnI+PGJyPlNvIEkgYW0gdHJ5aW5nIHRvIHJlc3RvcmUgYSBwZ19kdW1wICh2ZXJzaW9u OC4xCikgc3FsIGR1bXAgZmlsZSBmcm9tIGEgcmVtb3RlIDguMC4zIERCIGludG8gYSBsb2NhbCA4 LjEgREIgdXNpbmcgcGdfcmVzdG9yZSAodmVyc2lvbiA4LjEpLjxicj5JcyB0aGVyZSBzb21ldGhp bmcgaW5jb21wYXRpYmxlID8gPGJyPlRoZSBkdW1wIGZpbGUgc2VlbXMgdG8gYmUgY29ycmVjdCBy ZWdhcmRpbmcgaW5kZXggY3JlYXRpb24gc3RhdGVtZW50cy4uLiBJIHJlYWxseSBkb24ndCB1bmRl cnN0YW5kIHdoYXQgaXMgaGFwcGVuaW5nLgo8YnI+PGJyPkFzIHRoZSB0aXRsZSBtZW50aW9ucywg SSBoYXZlIHRoZSBzYW1lIGlzc3VlIHdpdGggdHJpZ2dlcnMgOiBub25lIG9mIG15IHRyaWdnZXJz IGFyZSByZXN0b3JlZCBuZWl0aGVyICEgSXMgdGhlcmUgYW55IG9wdGlvbiBpbiBwZ19kdW1wIG9y IHBnX3Jlc3RvcmUgdG8gaGFuZGxlIHRoaXMgPzxicj48YnI+PGJyPlJlZ2FyZHM8YnI+PGJyPlRo YW5rcyBpbiBhZHZhbmNlPGJyPgpEYXZpZCBMRVZZPGJyPgo= ------=_Part_24419_20410814.1146135559087--