Re: createuser ignores stdin in 8.1.0? - Mailing list pgsql-general

From Richard Huxton
Subject Re: createuser ignores stdin in 8.1.0?
Date
Msg-id 43909435.40206@archonet.com
Whole thread Raw
In response to createuser ignores stdin in 8.1.0?  (Gary Horton <Gary.Horton@Sun.COM>)
Responses Re: createuser ignores stdin in 8.1.0?
List pgsql-general
Gary Horton wrote:
> ...and in 7.3.4, this works just fine, with the shell consuming the
> stdin and redirecting it to the createuser command, which subsequently
> doesn't bother the user with the prompt (i.e. the prompts are responded
> to automatically). However, this doesn't work at all in 8.1.0 --
> regardless of the stdin redirection, the createuser program appears to
> ignore the stdin information and insists on prompting for the input
> instead.

Don't know what's changed, but it could be something that happened when
roles were introduced. A way to work around it would be to issue the SQL
"CREATE USER... PASSWORD 'foo'" via psql.

Oh - anything else you come across in the upgrade would be of interest
to many here, myself included ;-)

--
   Richard Huxton
   Archonet Ltd

pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: accessing text of the query in a rule
Next
From: Jaime Casanova
Date:
Subject: Re: Slow COUNT