Received: from localhost (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 2DD07634021 for ; Sun, 13 Sep 2009 12:07:30 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 63373-04 for ; Sun, 13 Sep 2009 15:07:19 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from qw-out-2122.google.com (qw-out-2122.google.com [74.125.92.27]) by mail.postgresql.org (Postfix) with ESMTP id 4D28D63388B for ; Sun, 13 Sep 2009 12:07:19 -0300 (ADT) Received: by qw-out-2122.google.com with SMTP id 3so666352qwe.61 for ; Sun, 13 Sep 2009 08:07:17 -0700 (PDT) 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=TtY6i10aJ47R9Xvkdk/pwFDbWwcBRx2m9l9Ql/7uD5Y=; b=aAfinXKjXCWj9E+L0hNIAW/jUIpwaoSoQ9CDr1aMyAq2QNpZ0gF7Rc2K2wjLQd45Rh QGUrbxc9NRGzF1y/UIvMBNGE3PbrUWiGGqNZZmpWEQyJiACj8h+n8cKCGQ6QcynEVr1f zWCDUFpWnQJJhFFdzwa3tDrCgELX2TzMv9PvE= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:date:message-id:subject:from:to:content-type; b=pYfGR6PYO/7ujP3wMBj1TQBE/vrIFcCtWRHG+6WQz8LOaNIDGj11QpKyXe1zyo0Axj ndWPWXuASIDOi+BNCKD7sNc1qzbgXlvRelXJL5HmvnsArNvkIVgAV25ME6GwGCrueogB 9DWLLC6QTtr2gayXiCQGqwGFz6azk9Cpnc7/Y= MIME-Version: 1.0 Received: by 10.229.41.13 with SMTP id m13mr1654174qce.85.1252854437529; Sun, 13 Sep 2009 08:07:17 -0700 (PDT) Date: Sun, 13 Sep 2009 20:37:17 +0530 Message-ID: Subject: schema proxying virtual database From: Rajesh Kumar Mallah To: postgres sql Content-Type: multipart/alternative; boundary=0016364173adb448a1047376e734 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.598 tagged_above=-10 required=5 tests=BAYES_00=-2.599, HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200909/52 X-Sequence-Number: 33117 --0016364173adb448a1047376e734 Content-Type: text/plain; charset=ISO-8859-1 [ sorry if it is a repost, i am not sure if i am subscribed in -general ] Dear List, There are many opensource applications that support postgresql (eg , gforge , bricolage , dspam ..) but does not use schemas(namespaces) as a result of which you are forced to use/create a new database and loose the advantage of linking the application data with your existing database. as no-cross database queries can be done in PG. my question is , is it a feasible idea to have some special kind of database in the postgresql cluster that mimics a schema of an existsing database. say rt3 is a special database that links to existing maindb databases' rt3 namespace then any DDL / DML done to public schema of rt3 database is redirected to rt3 namespace of the existing database maindb's rt3 schema. regds mallah. --0016364173adb448a1047376e734 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable 
[ sorry if it is a repost, i am not sure if i am subscribed in -genera=
l ]

Dear List,

There are many opensource applications that su=
pport postgresql
(eg , gforge , bricolage , dspam ..) but does not use s=
chemas(namespaces)

as a result of which you are forced to use/create a new database and loose<=
br>the
advantage of linking the application data with your existing data=
base.
as no-cross database queries can be done in PG.


my ques=
tion is , is it a feasible idea to have some special kind of database

in the postgresql cluster that mimics a schema of an existsing database.
say rt3 is a special database that links to existing maindb databases&=
#39;
rt3 namespace then  any DDL / DML done to public schema of rt3 data=
base

is redirected to rt3 namespace of the existing database maindb's rt3 sc=
hema.

regds
mallah.
--0016364173adb448a1047376e734--