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.

> Postgresql 7.1.3
>
> I'm having a problem with createlang.
>
> Commands:
>
> [postgres(at)boxy postgres]$ createdb test1
> Password: <----- Correct
> password
> CREATE DATABASE
> [postgres(at)boxy postgres]$ createlang plpgsql test1
> Password: <----- Correct
> password (does not say it was incorrect, the first character is upper
> case)
> Password: <-----
> Incorrect password "something"
> psql: Password authentication failed for user 'postgres'
> Password: <-----
> Incorrect password "something"
> psql: Password authentication failed for user 'postgres'
> createlang: language installation failed
> [postgres(at)boxy postgres]$
>
> Logs corresponding to those commands:
>
> 2001-10-22 15:15:22 [13115] DEBUG: connection: host=[local]
> user=postgres database=template1
> 2001-10-22 15:15:33 [13125] DEBUG: connection: host=[local]
> user=postgres database=test1
> Password authentication failed for user 'postgres'
> Password authentication failed for user 'postgres'
>
> pg_hba.conf entry:
> local all crypt
>
> Now again have a look at this (quite interesting):
>
> [postgres(at)boxy postgres]$ dropdb test1
> Password:
> DROP DATABASE
> [postgres(at)boxy postgres]$ createdb test1
> Password:
> CREATE DATABASE
> [postgres(at)boxy postgres]$ createlang -l test1
> Password:
> Procedural languages
> Name | Trusted? | Compiler
> ------+----------+----------
> (0 rows)
>
> [postgres(at)boxy postgres]$ createlang plpgsql test1
> Password:
> Password:
> Password:
> Password:
> [postgres(at)boxy postgres]$ createlang -l test1
> Password:
> Procedural languages
> Name | Trusted? | Compiler
> ---------+----------+----------
> plpgsql | t | PL/pgSQL
> (1 row)
>
> [postgres(at)boxy postgres]$
>
> I had to enter the password 4 times for it to create the language.
>
> Thanks.
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>

--
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