rather do an rpm -qa | grep post to see if postgresql-pl-7.3.4-2PGDG is installed, it is the rpm for procedural languages in 7.3.* and didn't exist in the 7.2.* rpmset.
Robert Treat On Fri, 2003-09-12 at 10:12, Richard Huxton wrote: > Please don't post html-only messages to the list, it makes quoting hard... > > On Friday 12 September 2003 14:49, vijaykumar M wrote: > > <P>We have a machine with RedhatLinix 7.2, on top of this i upgraded > > the postgresql7.3.3 version. After creating a database, i'm trying to > > create a language for that database by using <STRONG>createlang plpgsql > > <dnname></STRONG></P> <P>it throws an error " failed with some > > missing files". > > Hmm - we need to find out why the files are missing. First thing to try is > "locate plpgsql.so" and see if that can find your library. If so, make sure > you have its location added to /etc/ld.so.conf and re-run "ldconfig". > > If the file genuinely doesn't exist, did you install from RPM or source? > If RPM, try "rpm -ql postgresql-server" to see what files it thinks it > installed. > If source, can you remember what options you chose to compile with, or do you > have the source-directories still around? If you still have the source, > there'll be a file called configuration.cache or similar that should hold > your config options. > > > so, i copied /<STRONG>usr/local/pgsql/plpgsql.so > > </STRONG>from Redhatlinux8.0 machine and tried again to create a language. > > this time i got an error like <STRONG>'Load of file > > /usr/lib/pgsql/plpgsql.so failed :/lib/i686/libc.so.6: version GLIB_2.3 not > > found (required by /usr/lib/pgsql/plpgsql.so).</STRONG></P> > > RedHat changed their version of glibc between 7.2 and 8.0 - you can't just > move libraries between these versions. > > -- > Richard Huxton > Archonet Ltd > > ---------------------------(end of broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to [EMAIL PROTECTED] so that your > message can get through to the mailing list cleanly -- Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL ---------------------------(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