Re: Final stored procedure question, for now anyway

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