Re: database aliases?

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