Re: Show stored function code - Mailing list pgsql-novice

From Merlin Moncure
Subject Re: Show stored function code
Date
Msg-id CAHyXU0wFOqO9J+QEp1iyMC41DWXLJi9WovB1bjmfT3G+HZ8YSA@mail.gmail.com
Whole thread Raw
In response to Re: Show stored function code  (Mephysto <mephystoonhell@gmail.com>)
Responses Re: Show stored function code  (mephysto <mephystoonhell@gmail.com>)
List pgsql-novice
On Wed, Mar 28, 2012 at 9:05 AM, Mephysto <mephystoonhell@gmail.com> wrote:
> Oh, I'm sorry.
>
> My function are written in sql and plpgsql.

the source code should be in pg_proc.  try a schema only dump with
pg_dump -s and see if your code is there.  either you are querying
your functions wrong (upper/lower case issue?) or something else is
wrong, like the functions are not there.

merlin

pgsql-novice by date:

Previous
From: JORGE MALDONADO
Date:
Subject: How to pg_dump v9.0 with v9.1
Next
From: mephysto
Date:
Subject: Re: Show stored function code