From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | Gary Horton <Gary(dot)Horton(at)Sun(dot)COM> |
Cc: | Richard Huxton <dev(at)archonet(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: createuser ignores stdin in 8.1.0? |
Date: | 2005-12-02 20:52:48 |
Message-ID: | 200512022052.jB2Kqml19096@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Gary Horton wrote:
>
>
> Richard Huxton wrote:
>
> > 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.
>
> That's a great idea, Richard - thanks, I'll give this a shot --
createuser was converted from a shell script to a C program in 7.4, so I
guess something changed at that point.
--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2005-12-02 20:55:46 | Re: Numeric 508 datatype |
Previous Message | Jaime Casanova | 2005-12-02 20:48:23 | Re: accessing text of the query in a rule |