Re: whats the deal with -u ?

Gregory Stark wrote:
> "Tom Lane" <tgl@sss.pgh.pa.us> writes:
> 
> > Alvaro Herrera <alvherre@alvh.no-ip.org> writes:
> >> I have never understood what's the point of having an option to force a
> >> password prompt.  I wonder why don't we deprecate -W?
> >
> > It's not *completely* useless, because you only need one connection
> > attempt not two --- normally, psql gets rejected once before figuring
> > out that it must ask for a password.  
> 
> Hm, I wonder if this fixes one of the annoyances of kerberos support. If you
> have kerberos tickets psql uses the principal name from them rather than your
> unix username. If you don't actually use kerberos authentication for your
> postgres server then that means you have to specify the user on the command
> line all the time.

Huh, isn't this solved by just setting PGUSER?  (In any case I doubt -W
has any effect on it.)

-- 
Alvaro Herrera       Valdivia, Chile   ICBM: S 39º 49' 18.1", W 73º 13' 56.4"
"La vida es para el que se aventura"