misbehaving

From: PJourdan <info(at)lespetitsplaisirs(dot)com>
To: "Josh Berkus" <josh(at)agliodbs(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: misbehaving
Date: 2002-04-18 20:30:50
Message-ID: 5.1.0.14.2.20020418161100.00ad4a58@mail.host45.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

I am getting weird prompts when I do psql "database"
database=>
instead of
database=#

I finally got the prompt under one of the users, but not the one that is
supposed to be the superuser.

template1=# DROP DATABASE database
template1-#

The same happens with CREATE DATABASE
This is weird.
I find different attributes when I look at users and databases from
pgAdmin2 or from Webmin - and when I try to change user permissions
(CREATEDB, for example) I get some error code.
And when I last installed the plpgsql language I did not get ththe following:

postgres:~$ createlang plpgsql template1
postgres:~$ # Test if we succeeded
postgres:~$ createlang -l template1
Procedural languages
Name | Trusted? | Compiler
---------+----------+----------
plpgsql | t | PL/pgSQL
(1 row)

what I get is this:

postgres:~$ createlang plpgsql template1
postgres:~$ # Test if we succeeded
postgres:~$ createlang -l template1
Procedural languages
Name | Trusted?
---------+-------
plpgsql | t
(1 row)

There is no the information about the Compiler. In another installation, I
recall it was there.
The version of Postgreql installed is 7.2.1_1 - the latest in the FreeBSD
ports collection.
Help, please. :((

Browse pgsql-novice by date

  From Date Subject
Next Message PJourdan 2002-04-18 22:15:19 plpgsql
Previous Message Mark Thomas 2002-04-18 19:48:15 libpq - sample code?