text cast on regprocedure fails on 8.2 - Mailing list pgsql-admin

Hello,

for dropping all functions within the current schema I use this SQL query:

SELECT DISTINCT 'DROP FUNCTION ' || p.oid::regprocedure::text || ' CASCADE;' FROM pg_catalog.pg_proc p LEFT JOIN
pg_catalog.pg_namespacen ON n.oid = p.pronamespace WHERE n.nspname = current_schema(); 

It works fine on 8.3. It fails on 8.2 with the error message that conversion to text is not possible for data type
regprocedure.

I didn't see any explicit type cast in 8.3 for regprocedure -> text. Is there a way to add it in 8.2?

Thank you very much,

Peter
--
GRATIS für alle GMX-Mitglieder: Die maxdome Movie-FLAT!
Jetzt freischalten unter http://portal.gmx.net/de/go/maxdome01