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

Reply via email to