Re: Help! Can't pg_dump anything: handler procedure for procedural language plpgsql not found

Unfortunately,

That didn't work.

Thanks anyway.


----- Original Message -----
From: "Tom Lane" <tgl@sss.pgh.pa.us>
To: "Mark Mikulec" <mm98au@badger.ac.brocku.ca>
Cc: <pgsql-general@postgresql.org>
Sent: Tuesday, August 12, 2003 9:54 AM
Subject: Re: [GENERAL] Help! Can't pg_dump anything: handler procedure for
procedural language plpgsql not found


> mm98au@brocku.ca (Mark Mikulec) writes:
> > But i'd always get the following error message:
> >  pg_dump: handler procedure for procedural language plpgsql not found
>
> Do you have any functions written in plpgsql?  (I'm guessing not, or you
> would have other problems besides pg_dump not working.)  If not, you can
> just delete the pg_language entry for plpgsql:
>
> DELETE FROM pg_language WHERE lanname = 'plpgsql';
>
> If you do have any such functions, you should drop them first.
> (Alternatively, let pg_dump find them for you, and drop them in response
> to its complaints.)
>
> regards, tom lane
>
>