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@sss.pgh.pa.us>
To: "Brian G. Huber" <brianghuber@yahoo.com>
Cc: <pgsql-novice@postgresql.org>
Sent: Thursday, November 20, 2003 5:04 PM
Subject: Re: [NOVICE] Installation of plpgsql using createlang comand


> "Brian G. Huber" <brianghuber@yahoo.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