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

Re: database aliases?

From: Reece Hart <rkh(at)gene(dot)COM>
To: SF Postgres <sfpug(at)postgresql(dot)org>
Subject: Re: database aliases?
Date: 2003-04-07 17:29:05
Message-ID: 1049736545.1732.64.camel@tallac (view raw, whole thread or download thread mbox)
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 Hart, Ph.D.                       rkh(at)gene(dot)com,
Genentech, Inc.                         650/225-6133 (voice), -5389 (fax)
Bioinformatics and Protein Engineering
1 DNA Way, MS-93              
South San Francisco, CA  94080-4990     reece(at)in-machina(dot)com, GPG: 0x25EC91A0

In response to


sfpug by date

Next:From: Reece HartDate: 2003-04-07 18:51:29
Subject: Re: database aliases?
Previous:From: Josh BerkusDate: 2003-04-05 02:54:40
Subject: Re: database aliases?

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