Thread: Installation of plpgsql using createlang comand

Installation of plpgsql using createlang comand

From
"Brian G. Huber"
Date:
Hello all -
 
I am getting "ERROR:  No namespace has been selected to create in" when I try to use the createlang utility with the syntax-
 
createlang plpgsql dev
 
(where dev is DBNAME).  I can't seem to find any info in the docs on this.  Using 7.3.4 on Linux RedHat9.0. Any suggestions on how to install plpgsql greatly appreciated. Thanks,BGH

Re: Installation of plpgsql using createlang comand

From
Godshall Michael
Date:
What are running the command in? 
 
If you are using pgadminIII do in sql window
 
CREATE PROCEDURAL LANGUAGE 'plpgsql'
  HANDLER plpgsql_call_handler;
-----Original Message-----
From: Brian G. Huber [mailto:brianghuber@yahoo.com]
Sent: Thursday, November 20, 2003 4:08 PM
To: pgsql-novice@postgresql.org
Subject: [NOVICE] Installation of plpgsql using createlang comand

Hello all -
 
I am getting "ERROR:  No namespace has been selected to create in" when I try to use the createlang utility with the syntax-
 
createlang plpgsql dev
 
(where dev is DBNAME).  I can't seem to find any info in the docs on this.  Using 7.3.4 on Linux RedHat9.0. Any suggestions on how to install plpgsql greatly appreciated. Thanks,BGH

Re: Installation of plpgsql using createlang comand

From
Tom Lane
Date:
"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

Re: Installation of plpgsql using createlang comand

From
"Brian G. Huber"
Date:
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