I used the pg_dump from Postgres 8.0beta5 to dump the data from a version
7.4.0 database. Both databases are located on SuSE Linux machines. The
pg_restore to the 8.0 version went very well with the exception of the
languages. I have plpgsql and plsh installed in the 7.4.0 database. pg_dump
handled the dependencies for plpgsql alright but not for plsh. Searching the
archives showed a previous problem with languages installed to pg_catalog
which is were plsh is installed. However, I thought this had been solved. Is
this correct? The other thought that occurred to me is that plsh is an
untrusted language. I am dumping and restoring as user postgres so my
understanding is that this should overcome any permissions issues. Again am I
correct in thinking this?
--
Adrian Klaver
aklaver(at)comcast(dot)net