Postgres Pro
Downloads
Home   >   mailing lists

DROP LANGUAGE error in pg_dump? - Mailing list pgsql-general

From John Smith
Subject DROP LANGUAGE error in pg_dump?
Date
Msg-id 20030329063214.77408.qmail@web40706.mail.yahoo.com
Whole thread Raw
Responses Re: DROP LANGUAGE error in pg_dump?  (Bruce Momjian <pgman@candle.pha.pa.us>)
Re: DROP LANGUAGE error in pg_dump?  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-general
Tree view

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!

pgsql-general by date:

Previous
From: John Smith
Date:
Subject: changing owner of function
Next
From: "Dann Corbit"
Date:
Subject: Re: Slow query needs a kick in the pants.