| From: | Rajesh Kumar Mallah <mallah(dot)rajesh(at)gmail(dot)com> |
|---|---|
| To: | postgres sql <pgsql-sql(at)postgresql(dot)org> |
| Subject: | schema proxying virtual database |
| Date: | 2009-09-13 15:07:17 |
| Message-ID: | a97c77030909130807t653c874bk35b8b550d61d4b54@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
[ 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2009-09-13 18:37:59 | Re: Serious problems with non-primary foreign keys |
| Previous Message | Tom Lane | 2009-09-11 21:44:54 | Re: its posible to use a 2 column returning function as a subquery? |