droplang doesn't completely work?

From: Laurette Cisneros <laurette(at)nextbus(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: droplang doesn't completely work?
Date: 2002-09-13 17:34:04
Message-ID: Pine.LNX.4.44.0209131023560.3825-100000@visor.corp.nextbus.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


In 7.2.1

For database x:
1) On primary sytem:
pg_dump -f x.pgdmp -Fc x
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

So, I go back to primary system and
droplang -d x plperl

I do 1) and 2) again. Same ERROR.

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?

I know that if I never did a createlang plperl in a database it is not
there...so why does it stay? Is this what is still causing the error on
the pg_restore? Bug? Work around is to drop this record from the pg_proc
table?

Thanks,

--
Laurette Cisneros
The Database Group
(510) 420-3137
NextBus Information Systems, Inc.
www.nextbus.com
----------------------------------
A wiki we will go...

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Jan Wieck 2002-09-13 17:52:05 Re: TOAST docs
Previous Message Laurette Cisneros 2002-09-13 17:09:48 time default