cannot use createlang after removing public schema

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

Responses

Browse pgsql-general by date

  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