Received: from shaked.cc.openu.ac.il (shaked.cc.openu.ac.il [147.233.145.65]) by hub.org (8.9.3/8.9.3) with ESMTP id JAA04240 for ; Tue, 26 Oct 1999 09:47:04 -0400 (EDT) (envelope-from herouth@oumail.openu.ac.il) Received: from [147.233.159.109] (herouth@mac-herouth.pc.openu.ac.il [147.233.159.109]) by shaked.cc.openu.ac.il (8.8.8/8.8.8) with ESMTP id PAA23803; Tue, 26 Oct 1999 15:46:49 +0200 (IST) X-Sender: herouth@shaked.cc.openu.ac.il Message-Id: In-Reply-To: <19991025053156.6282.rocketmail@web124.yahoomail.com> Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Date: Tue, 26 Oct 1999 15:47:28 +0200 To: Dipankar Chakrabarti , pgsql-sql@hub.org From: Herouth Maoz Subject: Re: [SQL] pg_dump for PGPLSQL 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