createlang difficulty.

From: speedboy <speedboy(at)nomicrosoft(dot)org>
To: pgsql-hackers(at)postgresql(dot)org
Subject: createlang difficulty.
Date: 2001-10-22 05:24:28
Message-ID: Pine.LNX.4.21.0110221522200.15722-100000@bedrock.evark.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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.

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Thomas Lockhart 2001-10-22 05:51:42 Re: [GENERAL] To Postgres Devs : Wouldn't changing the select limit
Previous Message Jason Orendorff 2001-10-22 04:18:46 storing binary data