Skip site navigation (1) Skip section navigation (2)

createlang

From: jason(at)matchingmoms(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: createlang
Date: 2002-01-09 06:07:43
Message-ID: 000201c1997b$c8f4d440$6500a8c0@qwest.net (view raw or flat)
Thread:
Lists: pgsql-bugs
postgres(at)abigail ~/data $ createdb test1
Password:
CREATE DATABASE

postgres(at)abigail ~/data $ createlang --dbname=test1 --pglib=/usr/lib/pgsql
'plpgsql'
Password: Password: Password:
Password:

postgres(at)abigail ~/data $ createlang --list --dbname=test1
Password:
     Procedural languages
  Name   | Trusted? | Compiler
---------+----------+----------
 plpgsql | t        | PL/pgSQL
(1 row)


postgres(at)abigail ~/data $ dropdb test1
Password:
DROP DATABASE


----------------------------------------------------------------------------
-
----------------------------------------------------------------------------
-

The createlang does not accept my password correctly.  Also, should it not
give a confirmation such as "CREATE" when it executes?  One can see from the
above output that I had to enter it 4 times.  Note that it does not behave
this way when I enter the incorrect password (see below).

I'm on RedHat 7.1 and using the default Postgres RPM from my initial
install.

template1=# SELECT version()
template1-# ;
                           version
-------------------------------------------------------------
 PostgreSQL 7.0.3 on i686-pc-linux-gnu, compiled by gcc 2.96
(1 row)

postgres(at)abigail ~/data $ cat /proc/meminfo
        total:    used:    free:  shared: buffers:  cached:
Mem:  393175040 219648000 173527040  1470464 32092160 80633856
Swap: 271392768        0 271392768

----------------------------------------------------------------------------
-
----------------------------------------------------------------------------
-


postgres(at)abigail ~/data $ createdb test1
Password:
CREATE DATABASE

postgres(at)abigail ~/data $ createlang --dbname=test1 --pglib=/usr/lib/pgsql
'plpgsql'
Password: psql: Password authentication failed for user 'postgres'
createlang: external error

postgres(at)abigail ~/data $ createlang --list --dbname=test1
Password:
    Procedural languages
 Name | Trusted? | Compiler
------+----------+----------
(0 rows)


postgres(at)abigail ~/data $ dropdb test1
Password:
DROP DATABASE




Responses

pgsql-bugs by date

Next:From: Tim NelsonDate: 2002-01-09 13:25:54
Subject: ecpg "aborts" on structure reference
Previous:From: Tom LaneDate: 2002-01-08 17:20:45
Subject: Re: Bug #557: triggers tablename are not rename if table are renamed.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group