Adrian Klaver <[EMAIL PROTECTED]> writes: > 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?
This would be a more useful report had you said exactly what the problem was ... regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org