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

Problem dumping PL/pgsql functions.

From: "Billy G(dot) Allie" <Bill(dot)Allie(at)mug(dot)org>
To: hackers(at)postgresql(dot)org
Subject: Problem dumping PL/pgsql functions.
Date: 1998-10-05 05:22:38
Message-ID: 199810050522.BAA03575@bgalli.mug.org (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.
-- 
____       | Billy G. Allie    | Domain....: Bill(dot)Allie(at)mug(dot)org
|  /|      | 7436 Hartwell     | Compuserve: 76337,2061
|-/-|----- | Dearborn, MI 48126| MSN.......: B_G_Allie(at)email(dot)msn(dot)com
|/  |LLIE  | (313) 582-1540    | 



Responses

pgsql-hackers by date

Next:From: Marc G. FournierDate: 1998-10-05 05:28:18
Subject: Re: [HACKERS] Open 6.4 items
Previous:From: Gene Selkov Jr.Date: 1998-10-05 05:21:27
Subject: Re: [ADMIN] COPY slows down; is it normal?

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