Thread: pl/pgsql doesn't load

pl/pgsql doesn't load

From
"David B."
Date:
8.0.1 doesn't compile to include plpgsql.o so I can't createlang pl/pgsql.

Why don't you guys provide rpms for the major distributions anyway?  I'm
using
mandrake and because you don't provide rpms I have to use the --without
readline and zlib commands just to get it to compile.  I can't find a
mandrake rpm
of 8.0+ anywhere and I've spent 2 weeks just trying to get this up and
running.

I had this installed in microsoft in less than a day, but the linux source
is a major major
pain - sooooo0o
where do I go to get plpgsql.o so I can program my sql?

thanks
incomex@hotmail.com

Re: pl/pgsql doesn't load

From
Alvaro Herrera
Date:
On Sat, Mar 19, 2005 at 11:21:54PM -0700, David B. wrote:
> 8.0.1 doesn't compile to include plpgsql.o so I can't createlang pl/pgsql.

I think you have misidentified your problem.

> Why don't you guys provide rpms for the major distributions anyway?
> I'm using mandrake and because you don't provide rpms I have to use
> the --without readline and zlib commands just to get it to compile.  I
> can't find a mandrake rpm of 8.0+ anywhere and I've spent 2 weeks just
> trying to get this up and running.

It's very easy to use the .src.rpm from PGDG to recreate a binary RPMs
in Mandrakelinux.  In fact I used to do that back when I used Mandrake,
not many months ago.  You just need to install the rpm-build package and
follow the standard Mandrake instructions for building packages.  See
the Cooker documentation on that.

You have to install zlib-devel and some readline devel package in order
to compile cleanly, anyway.

--
Alvaro Herrera (<alvherre[@]dcc.uchile.cl>)
"The West won the world not by the superiority of its ideas or values
or religion but rather by its superiority in applying organized violence.
Westerners often forget this fact, non-Westerners never do."
(Samuel P. Huntington)

Re: pl/pgsql doesn't load

From
Neil Conway
Date:
David B. wrote:
> 8.0.1 doesn't compile to include plpgsql.o so I can't createlang pl/pgsql.

The 8.0.1 compile does create a plpgsql.so; it is installed under
$prefix/lib.

> Why don't you guys provide rpms for the major distributions anyway?

http://www.postgresql.org/ftp/binary/v8.0.1/linux/rpms/

-Neil