Re: Installation of plpgsql using createlang comand

Thanks Tom - yes I deleted the public schema- sounds like this may have been
a bad idea. Perhaps I could set the search path to the schema where the
language will be used (although it sounds like I'd have to install multiple
times for each schema within which I want to use the language?)

Sounds like a better plan is to add the public schema back into the
database. Thanks again.
----- Original Message -----
From: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Brian G. Huber" <brianghuber(at)yahoo(dot)com>
Cc: <pgsql-novice(at)postgresql(dot)org>
Sent: Thursday, November 20, 2003 5:04 PM
Subject: Re: [NOVICE] Installation of plpgsql using createlang comand

> "Brian G. Huber" <brianghuber(at)yahoo(dot)com> writes:
> > I am getting "ERROR: No namespace has been selected to create in" when
I t=
> > ry to use the createlang utility with the syntax-
> > createlang plpgsql dev
>
> Hmm, have you deleted the public schema or something like that? It's
> unhappy because the default search path is turning up empty.
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose an index scan if your
> joining column's datatypes do not match