When I dumped (via pg_dump) a database that had PL/pgsql functions defined, 
the following happened:

  CREATE FUNCTION val0_id (int4 ) RETURNS text AS 'unknown' LANGUAGE 'unknown';
  CREATE FUNCTION val1_id (int4 ) RETURNS text AS 'unknown' LANGUAGE 'unknown';
  CREATE FUNCTION val0_sect (text,char ) RETURNS text AS 'unknown' LANGUAGE
     'unknown';
  CREATE FUNCTION val1_sect (text,char ) RETURNS text AS 'unknown' LANGUAGE
     'unknown';

Apparently, pg_dump does not recognize/handle PL/pgsql functions yet.
-- 
____       | Billy G. Allie    | Domain....: Bill.Allie@mug.org
|  /|      | 7436 Hartwell     | Compuserve: 76337,2061
|-/-|----- | Dearborn, MI 48126| MSN.......: B_G_Allie@email.msn.com
|/  |LLIE  | (313) 582-1540    | 



Mon, 05 Oct 1998 01:22:38 -0400
"Billy G. Allie" <Bill.Allie@mug.org>
Problem dumping PL/pgsql functions.
>
> When I dumped (via pg_dump) a database that had PL/pgsql functions defined,
> the following happened:
>
>   CREATE FUNCTION val0_id (int4 ) RETURNS text AS 'unknown' LANGUAGE 'unknown';
>   CREATE FUNCTION val1_id (int4 ) RETURNS text AS 'unknown' LANGUAGE 'unknown';
>   CREATE FUNCTION val0_sect (text,char ) RETURNS text AS 'unknown' LANGUAGE
>      'unknown';
>   CREATE FUNCTION val1_sect (text,char ) RETURNS text AS 'unknown' LANGUAGE
>      'unknown';
>
> Apparently, pg_dump does not recognize/handle PL/pgsql functions yet.

    Seems  that  pg_dump  doesn't  lookup pg_language but has the
    languages hardcoded compiled in. That's not right. I'll  take
    a look at it.


Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#======================================== jwieck@debis.com (Jan Wieck) #



Mon, 5 Oct 1998 09:17:57 +0200 (MET DST)
jwieck@debis.com (Jan Wieck)
Re: [HACKERS] Problem dumping PL/pgsql functions.
> When I dumped (via pg_dump) a database that had PL/pgsql functions defined, 
> the following happened:
> 
>   CREATE FUNCTION val0_id (int4 ) RETURNS text AS 'unknown' LANGUAGE 'unknown';
>   CREATE FUNCTION val1_id (int4 ) RETURNS text AS 'unknown' LANGUAGE 'unknown';
>   CREATE FUNCTION val0_sect (text,char ) RETURNS text AS 'unknown' LANGUAGE
>      'unknown';
>   CREATE FUNCTION val1_sect (text,char ) RETURNS text AS 'unknown' LANGUAGE
>      'unknown';
> 
> Apparently, pg_dump does not recognize/handle PL/pgsql functions yet.

Is this still an open issue?

-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026


Sun, 11 Oct 1998 21:19:44 -0400 (EDT)
Bruce Momjian <maillist@candle.pha.pa.us>
Re: [HACKERS] Problem dumping PL/pgsql functions.
>> Apparently, pg_dump does not recognize/handle PL/pgsql functions yet.
> 
> Is this still an open issue?
> 

No - it is now working.

Bruce,

Do not apply the patches I sent recently (PostgreSQL 6.4 patches - portability 
related).  I will get a fresh copy of the CVS tree and recreate the patches.

Thanks.
-- 
____       | Billy G. Allie    | Domain....: Bill.Allie@mug.org
|  /|      | 7436 Hartwell     | Compuserve: 76337,2061
|-/-|----- | Dearborn, MI 48126| MSN.......: B_G_Allie@email.msn.com
|/  |LLIE  | (313) 582-1540    | 



Sun, 11 Oct 1998 21:28:15 -0400
"Billy G. Allie" <Bill.Allie@mug.org>
Re: [HACKERS] Problem dumping PL/pgsql functions. 