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...
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 |