Re: createlang difficulty.

I just tried it with current sources and got:
#$ aspg createlang plpgsql testPassword: <- bad passwordFATAL 1:  Password authentication failed for user
"postgres"psql:FATAL 1:  Password authentication failed for user "postgres"createlang: external error#$ aspg createlang
plpgsqltestPassword: <- correct passwordPassword: <- correct passwordPassword: <- correct passwordPassword: <- correct
password

Looks OK to me.

> Postgresql 7.1.3
> 
> I'm having a problem with createlang.
> 
> Commands:
> 
> [postgres@boxy postgres]$ createdb test1
> Password:                                                   <----- Correct
> password
> CREATE DATABASE
> [postgres@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@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@boxy postgres]$ dropdb test1
> Password:
> DROP DATABASE
> [postgres@boxy postgres]$ createdb test1
> Password:
> CREATE DATABASE
> [postgres@boxy postgres]$ createlang -l test1
> Password:
>     Procedural languages
>  Name | Trusted? | Compiler
> ------+----------+----------
> (0 rows)
> 
> [postgres@boxy postgres]$ createlang plpgsql test1
> Password:
> Password:
> Password:
> Password:
> [postgres@boxy postgres]$ createlang -l test1
> Password:
>      Procedural languages
>   Name   | Trusted? | Compiler
> ---------+----------+----------
>  plpgsql | t        | PL/pgSQL
> (1 row)
> 
> [postgres@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@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026