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
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly