Skip site navigation (1) Skip section navigation (2)

Re: database aliases?

From: Reece Hart <reece(at)in-machina(dot)com>
To: SF Postgres <sfpug(at)postgresql(dot)org>
Subject: Re: database aliases?
Date: 2003-04-07 18:51:29
Message-ID: 1049741489.26090.0.camel@tallac (view raw or flat)
Thread:
Lists: sfpug
On Fri, 2003-04-04 at 18:51, David Fetter wrote: 
> Would 7.3's new schema system help?

I don't think so. I'm already using schemas to separate elements of the
database which can stand apart.  While that's useful, it doesn't capture
what I want.

FWIW, the difficulty in creating an alias to a schema or a database
turns out to be the same: both are primary keys in pg_namespace and
pg_database respectively.  Since we can't have two names with the same
oid, hardlink-style aliases (same oid) are impossible; without this
constraint, the problem's still difficult (e.g., drop database would
have to watch reference counts).

Thanks for the replies.

-Reece

-- 
Reece Hart, Ph.D.                       rkh(at)gene(dot)com, http://www.gene.com/
Genentech, Inc.                         650/225-6133 (voice), -5389 (fax)
Bioinformatics and Protein Engineering
1 DNA Way, MS-93                        http://www.in-machina.com/~reece/
South San Francisco, CA  94080-4990     reece(at)in-machina(dot)com, GPG: 0x25EC91A0


In response to

sfpug by date

Next:From: David WheelerDate: 2003-04-30 02:16:27
Subject: OSCON Talk Needed
Previous:From: Reece HartDate: 2003-04-07 17:29:05
Subject: Re: database aliases?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group