DROP LANGUAGE error in pg_dump?
I just dropped plpgsql and it's handler and recreated them logged in as a superuser. Yet in the dump 'DROP LANGUAGE plpgsql' appears before '\connect superuser' - this causes a 'only superusers can drop procedural languages...' (since it's still logged in as the regular user before that point).
John
---------------------------------
Do you Yahoo!?
Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop!
I think this is fixed in 7.4.
---------------------------------------------------------------------------
John Smith wrote:
I just dropped plpgsql and it's handler and recreated them logged in as a superuser. Yet in the dump 'DROP LANGUAGE plpgsql' appears before '\connect superuser' - this causes a 'only superusers can drop procedural languages...' (since it's still logged in as the regular user before that point).
John
---------------------------------
Do you Yahoo!?
Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop!
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073Sorry, I should have said this _will_ be fixed in 7.4.
---------------------------------------------------------------------------
John Smith wrote:
I just dropped plpgsql and it's handler and recreated them logged in as a superuser. Yet in the dump 'DROP LANGUAGE plpgsql' appears before '\connect superuser' - this causes a 'only superusers can drop procedural languages...' (since it's still logged in as the regular user before that point).
John
---------------------------------
Do you Yahoo!?
Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop!
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073