Thread: 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'sstill 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
Sorry, 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'sstill 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