Yes, this is the counter case, where the '@' disappears; so it appears
magically for local users, and disappears for global users.
---------------------------------------------------------------------------
Robert Treat wrote:
> Is the converse to this:
>
> $ psql -U postgres@ test
>
> Welcome to psql 7.3devel, the PostgreSQL interactive terminal.
>
> Type: \copyright for distribution terms
> \h for help with SQL commands
> \? for help on internal slash commands
> \g or terminate with semicolon to execute query
> \q to quit
>
> test=> select current_user;
> current_user
> --------------
> postgres
> (1 row)
>
>
> this seems counterintuitive to me, so I'd like to see the strong
> practical application that makes it necessary. (This is where mark comes
> in I suppose)
>
> Robert Treat
>
> On Tue, 2002-08-27 at 15:43, Bruce Momjian wrote:
> > Lamar Owen wrote:
> > > On Tuesday 27 August 2002 03:19 pm, Bruce Momjian wrote:
> > > > I think we need to resolve this discussion from a week ago. The current
> > > > code is this:
> > >
> > > I thought it WAS resolved, to do:
> > >
> > > > global usernames are stored just like before, e.g. postgres
> > > > local users are stored as user@dbname
> > > > when connecting, global users add '@' to their names
> > > > when connecting, local users use just their user name, no @dbname
> > >
> > > > 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.
> > >
> > > Basically, this tags the @ as magic saying, during the client connect process,
> > > 'I'm GLOBAL, treat me differently'. Now that I actually understand how this
> > > is supposed to work, which your four lines above elucidate nicely, I am in
> > > more agreement than I was that this is the right answer to this issue.
> >
> > 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:
> >
> > $ psql -U dave test
> > Welcome to psql 7.3devel, the PostgreSQL interactive terminal.
> >
> > Type: \copyright for distribution terms
> > \h for help with SQL commands
> > \? for help on internal slash commands
> > \g or terminate with semicolon to execute query
> > \q to quit
> >
> > test=> select current_user;
> > current_user
> > --------------
> > dave@test
> > (1 row)
> >
> > they will see their full username.
> >
> > I can go either way. I am just saying we need to hear from more people
> > to make sure we are doing this properly.
> >
> > --
> > Bruce Momjian | http://candle.pha.pa.us
> > pgman@candle.pha.pa.us | (610) 359-1001
> > + If your life is a hard drive, | 13 Roberts Road
> > + Christ can be your backup. | Newtown Square, Pennsylvania 19073
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 5: Have you checked our extensive FAQ?
> >
> > http://www.postgresql.org/users-lounge/docs/faq.html
>
>
>
>
-- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610)
359-1001+ If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square,
Pennsylvania19073
