Re: [SQL] plpgsql error

From: Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
To: Jan Wieck <jwieck(at)debis(dot)com>
Cc: Andy Lewis <alewis(at)themecca(dot)net>, apendleton(at)vgsinc(dot)com, pgsql-sql(at)hub(dot)org
Subject: Re: [SQL] plpgsql error
Date: 1999-05-11 14:56:42
Message-ID: 199905111456.KAA16248@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-sql

> >
> > 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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 1999-05-11 15:07:37 Re: AW: AW: [HACKERS] misc and triggers regression tests failed on 6. 5bet a1
Previous Message Tom Lane 1999-05-11 14:43:56 Re: [HACKERS] Date/Time Flaw in pg_dump ?

Browse pgsql-sql by date

  From Date Subject
Next Message Dr. Nisai Wanakule 1999-05-11 17:25:50 RE: [SQL] plpgsql error
Previous Message Tom Lane 1999-05-11 14:28:38 Re: [SQL] plpgsql error