droplang doesn't completely work?
От | Laurette Cisneros |
---|---|
Тема | droplang doesn't completely work? |
Дата | |
Msg-id | Pine.LNX.4.44.0209131023560.3825-100000@visor.corp.nextbus.com обсуждение исходный текст |
Ответы |
Re: droplang doesn't completely work?
|
Список | 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...
В списке pgsql-hackers по дате отправления: