From: | "Lee Harr" <missive(at)hotmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | cannot use createlang after removing public schema |
Date: | 2004-02-18 19:24:13 |
Message-ID: | BAY2-F73q2EkW66oTEe0000d8e5@hotmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Froggy / Froggy Corp. | 2004-02-18 20:18:37 | Need help with postgresql/apache/php optimisation |
Previous Message | Lincoln Yeoh | 2004-02-18 18:31:47 | Re: PostgreSQL Indexing versus MySQL |