Richard Bayet <bayet(at)enseirb(dot)fr> writes:
> And the problem is that they can't add any language support with
> createlang.
> Anytime they tried (for example '$>createlang plpgsql theirdb'), the
> program seemed to "freeze" on authentification ...
> They got a :
> "$> createlang plpgsql theirdb
> Password: THEIRPASS Password: THEIRPASS Password: THEIRPASS"
They just needed to be a little more patient ;-) IIRC, the createlang
script invokes psql four or five times, so if you are using password
authentication you're going to have to enter the password four or five
times.
I agree, this isn't particularly user-friendly ... but then, password
auth is inherently not user-friendly for something you invoke
frequently. You might want to look at the other auth methods.
regards, tom lane