Re: Final stored procedure question, for now anyway - Mailing list pgsql-general

From Guy Rouillier
Subject Re: Final stored procedure question, for now anyway
Date
Msg-id CC1CF380F4D70844B01D45982E671B239E8DC0@mtxexch01.add0.masergy.com
Whole thread Raw
In response to Final stored procedure question, for now anyway  ("Ted Byers" <r.ted.byers@rogers.com>)
List pgsql-general
Ted Byers wrote:

> It must be stored somewhere since I get an error saying the function
> already exists if I attempt to modiy it slightly and re-run it.  For
> example, I noticed I used the wrong sequence in the last INSERT
> statement.  To correct that, I had to add "OR REPLACE" after "CREATE"
> to make the correction.   I am puzzled though that I can't find it
> when I go back to the pgAmin main window and search through the whole
> database (after pressing <F5> to refresh the contents of the
> windows).

In PgAdmin, make sure you are looking under the correct schema.  Each
schema has its own set of objects.

--
Guy Rouillier

pgsql-general by date:

Previous
From: merlyn@stonehenge.com (Randal L. Schwartz)
Date:
Subject: Re: sending mail from Postgres
Next
From: "Jonel Rienton"
Date:
Subject: Re: Final stored procedure question, for now anyway