Skip site navigation (1) Skip section navigation (2)

Re: [HACKERS] Problem dumping PL/pgsql functions.

From: Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
To: Bill(dot)Allie(at)mug(dot)org
Cc: hackers(at)postgreSQL(dot)org
Subject: Re: [HACKERS] Problem dumping PL/pgsql functions.
Date: 1998-10-12 01:19:44
Message-ID: 199810120119.VAA28668@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
> 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(at)candle(dot)pha(dot)pa(dot)us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026


In response to

pgsql-hackers by date

Next:From: Billy G. AllieDate: 1998-10-12 01:28:15
Subject: Re: [HACKERS] Problem dumping PL/pgsql functions.
Previous:From: Bruce MomjianDate: 1998-10-12 01:16:10
Subject: Re: [HACKERS] select * from ..;vacuum crashes

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group