Re: [SQL] plpgsql error

>
> 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) #