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 [EMAIL PROTECTED]
---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
