Re: droplang doesn't completely work?

Laurette Cisneros writes:

> 2) On a bkuphost system that has 7.2.2:
> createdb -T template0 x
> pg_restore -U xuser -h bkuphost -p 5432 -d x -Fc x.pgdmp
>
> get error:
> pg_restore: [archiver (db)] could not execute query: ERROR:
> stat failed on file '/usr/local/pgsql-7.2/lib/plpgsql': No such file or
> directory

Well, is that file (+ .so) there? What does this path refer to? Is it
the correct installation location?

> So, I go back to primary system and
> droplang -d x plperl
>
> I do 1) and 2) again. Same ERROR.

Not surprising, since the error refers to plpgsql, not plperl.

> So, I go back to primary system again, and for database x:
> select proname, probin from pg_proc
>
> and see:
> ...
> plperl_call_handler | $libdir/plperl
> ...
>
> Shouldn't this be gone after I droplang?

Maybe you still have plperlu installed, in which case the language handler
is kept. Otherwise the answer is yes and you should try to see what
droplang is doing wrong.

--
Peter Eisentraut peter_e(at)gmx(dot)net