By creating a pgsql subdirectory under /usr/lib and manually moving files into this directory I was able to get the load to work. I queried the lib package and all of it's contents get installed at /usr/lib not /usr/lib/pgsql. However, the offending file appears to have been plpgsql.so which isn't part of any packages according to rpm. I don't know where this file comes from in the install process or why I had to make a pgsql subdirectory for this file. Now, on to tweaking NSD.TCL...
