cannot use createlang after removing public schema

Поиск
Список
Период
Сортировка
От Lee Harr
Тема cannot use createlang after removing public schema
Дата
Msg-id BAY2-F73q2EkW66oTEe0000d8e5@hotmail.com
обсуждение исходный текст
Ответы Re: cannot use createlang after removing public schema  (Richard Huxton <dev@archonet.com>)
Re: cannot use createlang after removing public schema  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
I have a database where I remove the schema public. When I
try to use the createlang script, it fails like this ...

>createdb foo
CREATE DATABASE
>psql foo -c "select version()"
                               version
---------------------------------------------------------------------
PostgreSQL 7.4.1 on i386-portbld-freebsd4.9, compiled by GCC 2.95.4
(1 row)
>createlang plpgsql foo
>dropdb foo
DROP DATABASE
>createdb foo
CREATE DATABASE
>psql foo -c "drop schema public"
DROP SCHEMA
>createlang plpgsql foo
createlang: language installation failed: ERROR:  no schema has been
selected to create in



I read through the man page, but I do not see how to specify the
schema to createlang ...

I can add the language using the manual syntax, I am just wondering if
there is a simple way to use the script.

_________________________________________________________________
Tired of spam? Get advanced junk mail protection with MSN 8.
http://join.msn.com/?page=features/junkmail


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

Предыдущее
От: Lincoln Yeoh
Дата:
Сообщение: Re: PostgreSQL Indexing versus MySQL
Следующее
От: "Froggy / Froggy Corp."
Дата:
Сообщение: Need help with postgresql/apache/php optimisation