-U option in psql

Lists: pgsql-hackers
From: "Jaime Casanova" <systemguards(at)gmail(dot)com>
To: "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Subject: -U option in psql
Date: 2008-02-12 04:57:59
Message-ID: c2d9e70e0802112057v13ec689cvf163b9b11bc5ea0c@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

Hi,

In 8.3.0 (windows installation) if I execute this command i get an
error while in 8.2 i get a psql command prompt, is this a change in
behaviour or a bug?

H:\Archivos de programa\PostgreSQL\8.3\bin>psql template1 -U postgres
psql: warning: extra command-line argument "postgres" ignored
Password for user -U:
psql: fe_sendauth: no password supplied

--
regards,
Jaime Casanova

"Programming today is a race between software engineers striving to
build bigger and better idiot-proof programs and the universe trying
to produce bigger and better idiots.
So far, the universe is winning."
Richard Cook


From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Jaime Casanova" <systemguards(at)gmail(dot)com>
Cc: "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: -U option in psql
Date: 2008-02-12 05:04:32
Message-ID: 17612.1202792672@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

"Jaime Casanova" <systemguards(at)gmail(dot)com> writes:
> In 8.3.0 (windows installation) if I execute this command i get an
> error while in 8.2 i get a psql command prompt, is this a change in
> behaviour or a bug?

> H:\Archivos de programa\PostgreSQL\8.3\bin>psql template1 -U postgres
> psql: warning: extra command-line argument "postgres" ignored

Putting switches after non-switch arguments has never been supported.
On some platforms it works ... sometimes.

regards, tom lane