Re: createlang difficulty.

> > I just tried it with current sources and got:
> >
> > #$ aspg createlang plpgsql test
> > Password: <- bad password
> > FATAL 1: Password authentication failed for user "postgres"
> > psql: FATAL 1: Password authentication failed for user "postgres"
> >
> > createlang: external error
> > #$ aspg createlang plpgsql test
> > Password: <- correct password
> > Password: <- correct password
> > Password: <- correct password
> > Password: <- correct password
> >
> > Looks OK to me.
>
> Ok, so it connects four times. From a users perspective that might be
> confusing. Is it possible to only prompt once for the password, just an
> idea I guess whoever created the program would want that to happen from a
> easy to use point of view. I.e. dummy proof?

Uh, yes, connecting once would be ideal. It currently runs each SQL
query it needs in psql and checks the exit status. Not sure how to code
that in one psql session.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026