misbehaving
| От | PJourdan |
|---|---|
| Тема | misbehaving |
| Дата | |
| Msg-id | 5.1.0.14.2.20020418161100.00ad4a58@mail.host45.com обсуждение исходный текст |
| Список | 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. :((
В списке pgsql-novice по дате отправления: