Thread

1. plpgsql error

   Adam H. Pendleton <apendleton@vgsinc.com> — 1999-05-10T20:32:09Z

   I get this error when I try to create a function using plpgsql:
   
   ERROR:  Unrecognized language specified in a CREATE FUNCTION: 'plpgsql'.
   Recognized languages are sql, C, internal and the created procedural
   languages.
   
   Do I need to specify another flag when I compile Postgresql?
   
   Adam
   ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
   Si hoc legere scis nimium eruditionis habes.
   
   
   
   

2. Re: [SQL] plpgsql error

   Andy Lewis <alewis@themecca.net> — 1999-05-10T21:05:22Z

   Edit: /usr/src/pgsql/postgresql-6.4.2/src/pl/plpgsql/src/mklang.sql
   
   Change: as '${exec_prefix}/lib/plpgsql.so'
   to: as '/usr/local/pgsql/lib/plpgsql.so'
   
   Then: psql your_db < mklang.sql
   
   This should really be part of the documentation as I wasted two days on
   this same problem a few weeks back.
   
   Have fun
   
   Andy
   
   On Mon, 10 May 1999, Adam H. Pendleton wrote:
   
   > I get this error when I try to create a function using plpgsql:
   > 
   > ERROR:  Unrecognized language specified in a CREATE FUNCTION: 'plpgsql'.
   > Recognized languages are sql, C, internal and the created procedural
   > languages.
   > 
   > Do I need to specify another flag when I compile Postgresql?
   > 
   > Adam
   > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
   > Si hoc legere scis nimium eruditionis habes.
   > 
   > 
   > 
   
   
   
   
   

3. Re: [SQL] plpgsql error

   Bruce Momjian <maillist@candle.pha.pa.us> — 1999-05-10T21:38:16Z

   Yes, this clearly looks broken.  In mklang.sql.in, @libdir@ is replaced
   with ${exec_prefix} in mklang.sql.  Seems it should be something else.
   
   
   > Edit: /usr/src/pgsql/postgresql-6.4.2/src/pl/plpgsql/src/mklang.sql
   > 
   > Change: as '${exec_prefix}/lib/plpgsql.so'
   > to: as '/usr/local/pgsql/lib/plpgsql.so'
   > 
   > Then: psql your_db < mklang.sql
   > 
   > This should really be part of the documentation as I wasted two days on
   > this same problem a few weeks back.
   > 
   > Have fun
   > 
   > Andy
   > 
   > On Mon, 10 May 1999, Adam H. Pendleton wrote:
   > 
   > > I get this error when I try to create a function using plpgsql:
   > > 
   > > ERROR:  Unrecognized language specified in a CREATE FUNCTION: 'plpgsql'.
   > > Recognized languages are sql, C, internal and the created procedural
   > > languages.
   > > 
   > > Do I need to specify another flag when I compile Postgresql?
   > > 
   > > Adam
   > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
   > > Si hoc legere scis nimium eruditionis habes.
   > > 
   > > 
   > > 
   > 
   > 
   > 
   > 
   > 
   
   
   -- 
     Bruce Momjian                        |  http://www.op.net/~candle
     maillist@candle.pha.pa.us            |  (610) 853-3000
     +  If your life is a hard drive,     |  830 Blythe Avenue
     +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026
   
   

4. Re: [SQL] plpgsql error

   Jan Wieck <jwieck@debis.com> — 1999-05-11T07:35:27Z

   >
   > Edit: /usr/src/pgsql/postgresql-6.4.2/src/pl/plpgsql/src/mklang.sql
   >
   > Change: as '${exec_prefix}/lib/plpgsql.so'
   > to: as '/usr/local/pgsql/lib/plpgsql.so'
   >
   > Then: psql your_db < mklang.sql
   >
   > This should really be part of the documentation as I wasted two days on
   > this same problem a few weeks back.
   
       And this became IMHO an FAQ. Should we avoid it by installing
       PL/pgSQL and PL/Tcl (if built) by default  in  the  template1
       database  during  intidb?   Installing  it in template1 would
       have the  effect  that  it  will  be  available  after  every
       createdb.
   
   
   Jan
   
   --
   
   #======================================================================#
   # It's easier to get forgiveness for being wrong than for being right. #
   # Let's break this rule - forgive me.                                  #
   #======================================== jwieck@debis.com (Jan Wieck) #
   
   
   
   

5. Re: [SQL] plpgsql error

   Bruce Momjian <maillist@candle.pha.pa.us> — 1999-05-11T14:56:42Z

   > >
   > > Edit: /usr/src/pgsql/postgresql-6.4.2/src/pl/plpgsql/src/mklang.sql
   > >
   > > Change: as '${exec_prefix}/lib/plpgsql.so'
   > > to: as '/usr/local/pgsql/lib/plpgsql.so'
   > >
   > > Then: psql your_db < mklang.sql
   > >
   > > This should really be part of the documentation as I wasted two days on
   > > this same problem a few weeks back.
   > 
   >     And this became IMHO an FAQ. Should we avoid it by installing
   >     PL/pgSQL and PL/Tcl (if built) by default  in  the  template1
   >     database  during  intidb?   Installing  it in template1 would
   >     have the  effect  that  it  will  be  available  after  every
   >     createdb.
   
   Sure, why not?
   
   
   -- 
     Bruce Momjian                        |  http://www.op.net/~candle
     maillist@candle.pha.pa.us            |  (610) 853-3000
     +  If your life is a hard drive,     |  830 Blythe Avenue
     +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026