Thread: pg_dump for PGPLSQL

Hi All!

I have posted this message a week back. But got no
response.

It will be helpful if somebody provides some help!!

When I am trying to use pg_dump for a database having
functions and triggres, it is giving error
"dumpProcLangs(): handler procedure for language
plpgsql not found."

It is dumping the data and the create script properly
but not the functions.

Need help.

Regards,

Dipankar Chakrabarti
Senior Manager (Projects)
MIL 


__________________________________________________
Do You Yahoo!?
Bid and sell for free at http://auctions.yahoo.com

At 07:31 +0200 on 25/10/1999, Dipankar Chakrabarti wrote:


> I have posted this message a week back. But got no
> response.
>
> It will be helpful if somebody provides some help!!
>
> When I am trying to use pg_dump for a database having
> functions and triggres, it is giving error
> "dumpProcLangs(): handler procedure for language
> plpgsql not found."
>
> It is dumping the data and the create script properly
> but not the functions.

Sounds to me like you are using pg_dump from an old version of PostgreSQL,
like 6.3 or something.

Herouth

--
Herouth Maoz, Internet developer.
Open University of Israel - Telem project
http://telem.openu.ac.il/~herutma