Search Postgresql Archives

Re: Final stored procedure question, for now anyway

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux