Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 432A01337B7B for ; Sun, 31 Oct 2010 20:07:46 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 54155-08 for ; Sun, 31 Oct 2010 23:07:40 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-iw0-f174.google.com (mail-iw0-f174.google.com [209.85.214.174]) by mail.postgresql.org (Postfix) with ESMTP id E4C141336473 for ; Sun, 31 Oct 2010 20:07:38 -0300 (ADT) Received: by iwn10 with SMTP id 10so6319646iwn.19 for ; Sun, 31 Oct 2010 16:07:38 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from :user-agent:mime-version:to:cc:subject:references:in-reply-to :content-type:content-transfer-encoding; bh=ZqMmb2KTee3cAqcwUyV4nzNNER8dIQOohsEFPFlRZh4=; b=Dmp2bEKEqQjK0pYLS6c0lO9j4V2KvrsFS5vl1uzLHaXA83KDTbtVlr7tfd3/4vPK/W FQWNfb0hqmKardV6fs2c4mydZaRD0Phqp6firA+3ZiKiJ4XLZ841uj/VBpeHuS5uYe2R 1WaeE2cw4xBk0V/ByCrom9H2NqBCklbMxUWgE= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:user-agent:mime-version:to:cc:subject :references:in-reply-to:content-type:content-transfer-encoding; b=iWRUWP74ocBET5SILUi1fGhK+UEuC51cjedqi0/M9+Al/tuYJGQvvwU9daqWe3hxTQ 1wM9nyPfOgX216i8a0GNtG7TQCPZuvzo1Om2ECII/wQzcTQl9sDGy/1LhY8L1fk/rbqz 6Ly+SKLWNULVKn0qO2wgww9yeCGodxMmuUA0c= Received: by 10.231.160.205 with SMTP id o13mr7103309ibx.15.1288566458744; Sun, 31 Oct 2010 16:07:38 -0700 (PDT) Received: from [192.168.0.2] (rsargent.dsl.xmission.com [199.104.125.126]) by mx.google.com with ESMTPS id 8sm7492392iba.10.2010.10.31.16.07.36 (version=TLSv1/SSLv3 cipher=RC4-MD5); Sun, 31 Oct 2010 16:07:38 -0700 (PDT) Message-ID: <4CCDF6B4.6020007@gmail.com> Date: Sun, 31 Oct 2010 17:07:32 -0600 From: Rob Sargent User-Agent: Thunderbird 2.0.0.24 (X11/20100411) MIME-Version: 1.0 To: =?UTF-8?B?VmlrdG9yIEJvam92acSH?= CC: pgsql-sql@postgresql.org Subject: Re: large xml database References: <4CCDD4B0.7030605@gmail.com> <4CCDDEE9.9010803@gmail.com> In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-5 required=5 tests=BAYES_00=-1.9, RCVD_IN_DNSWL_NONE=-0.0001 X-Spam-Level: X-Archive-Number: 201010/87 X-Sequence-Number: 34738 Skipping much of the included thread, urgently. > btw. > you have mentioned "This I believe would parse nicely into a tidy but > non-trivial schema directly", does it mean that postgre has a support > for restoring the database schema from xml files? > > -- > --------------------------------------- > Viktor Bojović > --------------------------------------- > Wherever I go, Murphy goes with me No. Sorry. Did not mean to imply that. If you had a xsd file from them you might have a better chance. Have never looked but I but someone has tried that sort of manipulation. Throw out the cardinality constraints of course :).