Re: Open 7.3 items

From: Lamar Owen <lamar(dot)owen(at)wgcr(dot)org>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: Peter Eisentraut <peter_e(at)gmx(dot)net>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Open 7.3 items
Date: 2002-08-27 20:05:36
Message-ID: 200208271605.36660.lamar.owen@wgcr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tuesday 27 August 2002 03:43 pm, Bruce Momjian wrote:
> Lamar Owen wrote:
> > On Tuesday 27 August 2002 03:19 pm, Bruce Momjian wrote:
> > I thought it WAS resolved, to do:

> > > Tom likes this because it is the fewer global users who have to append
> > > the '@'.

> > At least that was my perception of the uneasy consensus reached.

> OK, you have now split the vote because we have two for the change, and
> two against. Why do you prefer to tag the globals? Is it Tom's
> argument? I think it is kind of strange to tag the globals when it is
> the locals who have @ in their username, and when they do:

I agree with what Tom said, and understand why he said it. And I thought you
did, too -- I have apparently misunderstood (again!) the issue.

In the local-enabled scheme, ISTM the majority of users will be local users.
The goal is transparent virtual databases -- at least that's what I consider
the goal. As far as the user is concerned, the other databases might as well
not even exist -- all they are doing is connecting to their database. Since
they have to give the database name as part of the connection, it just makes
sense that they should have the closest to default behavior.

In the case of a virtual hosting postmaster, global users would likely be
DBA's, although they might not be. These users are going to be the
exception, not the rule -- thus a character to tag their 'exceptional'
nature.

You may not even want your virtual host local users to realize that there is
another user by that name. Thus, the standard notation is the least
intrusive for the very users that need uninstrusive notation.
--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2002-08-27 20:08:53 Re: REINDEX ALL and CLUSTER ALL
Previous Message Bruce Momjian 2002-08-27 19:58:36 Re: bug in COPY