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 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 Wheeler||Date: 2003-04-30 02:16:27|
|Subject: OSCON Talk Needed|
|Previous:||From: Reece Hart||Date: 2003-04-07 17:29:05|
|Subject: Re: database aliases?|