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@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
  [EMAIL PROTECTED]               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Reply via email to