Postgres Pro
Downloads
Home   >   mailing lists

Re: [HACKERS] Problem dumping PL/pgsql functions. - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: [HACKERS] Problem dumping PL/pgsql functions.
Date
Msg-id 199810120119.VAA28668@candle.pha.pa.us
Whole thread Raw
In response to Problem dumping PL/pgsql functions.  ("Billy G. Allie" <Bill.Allie@mug.org>)
Responses Re: [HACKERS] Problem dumping PL/pgsql functions.  ("Billy G. Allie" <Bill.Allie@mug.org>)
List pgsql-hackers
Tree view 
> 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

pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] select * from ..;vacuum crashes
Next
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] Open 6.4 items