Re: Triggers and Multiple Schemas.

From: Louis Gonzales <louis(dot)gonzales(at)linuxlouis(dot)net>
To: Scott Marlowe <smarlowe(at)g2switchworks(dot)com>
Cc: Paul Newman <paul(dot)newman(at)tripoint(dot)co(dot)uk>, pgsql general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Triggers and Multiple Schemas.
Date: 2006-03-08 20:42:57
Message-ID: 440F41D1.1080904@linuxlouis.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Paul,
What is the current schema layout for your db instances? I don't think
it's possible to share across db instances like this:

dbname1.myschema.sometable
dbname2.myschema.sometable

But you can share resources of the following type:

dbname.myschema1.sometable
dbname.myschema2.sometable
dbname.myschema2.sometable2
dbname.myschema2.sometable3

I think that it's a mis-statement to call each separate schema a DB, but
the group of:
dbname.myschema2.(collection of objects) is effectively a separate DB,
in that, the tables are what constitute a functional db.

so you can treat
dbname.myschema1.(...)
and
dbname.myschema2.(...)
as separate databases that share common resources, because they belong
to the same db instances, namely "dbname"

Attachment Content-Type Size
louis.gonzales.vcf text/x-vcard 170 bytes

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2006-03-08 20:49:28 Re: 8.0 Client can't connect to 7.3 server?
Previous Message Michael Fuhr 2006-03-08 20:41:46 Re: Triggers and Multiple Schemas.