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