Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 98BDD9FBE91 for ; Fri, 1 Jun 2007 15:16:32 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 68195-04 for ; Fri, 1 Jun 2007 15:16:32 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from web54304.mail.re2.yahoo.com (web54304.mail.re2.yahoo.com [206.190.49.114]) by postgresql.org (Postfix) with SMTP id B67839FB62C for ; Fri, 1 Jun 2007 15:16:31 -0300 (ADT) Received: (qmail 31790 invoked by uid 60001); 1 Jun 2007 18:16:29 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=QERS2/ybD5jZbYwQ6jFf3CVPoo3UxklXhamc4p57tQoSkmdAjE8kB1FumMjj7nXutU/i+mfFmC0rJbVZ7kwGWk7BMc8HTTW2lEMMW8Tvic6u8hELeKISQWC6hDkxZ3wmprJigHZVEXqCsGbL3plbTgovLrjLif0TZLMtAoKwIBc=; X-YMail-OSG: AL62m8UVM1kwvLRIKsNr9dm5F9TsygcEOfDrPZ9_FMun7j5uDXT24Mldom2P4RyhKUPvBcHw.29ZB.4GLJY6OU9YF6zCVX58vsg7rlFHciABbo4262hYNZ_g_IXKwtIqVItDYWOj6Y33xwY- Received: from [24.2.63.115] by web54304.mail.re2.yahoo.com via HTTP; Fri, 01 Jun 2007 11:16:29 PDT Date: Fri, 1 Jun 2007 11:16:29 -0700 (PDT) From: chester c young Subject: schema propagation To: sql pgsql MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Message-ID: <470697.16672.qm@web54304.mail.re2.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200706/4 X-Sequence-Number: 28494 Hi has anyone done any work on comparing schemas? I'm trying to automatically propagate changes in a master schema to child schemas. All schema changes will originate at master. Currently child schemas are in the same database, but in the future might be in different databases (clusters?). thanks! ____________________________________________________________________________________ Fussy? Opinionated? Impossible to please? Perfect. Join Yahoo!'s user panel and lay it on us. http://surveylink.yahoo.com/gmrs/yahoo_panel_invite.asp?a=7