createlang difficulty.

Поиск
Список
Период
Сортировка
От speedboy
Тема createlang difficulty.
Дата
Msg-id Pine.LNX.4.21.0110221522200.15722-100000@bedrock.evark.com
обсуждение исходный текст
Ответы Re: createlang difficulty.  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список pgsql-hackers
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 languagesName | 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.



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Haller Christoph
Дата:
Сообщение: Re: Catalogs design question
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Creating unique constraints on OID