Re: pg_dump and languages

Adrian Klaver <aklaver(at)comcast(dot)net> 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