Re: Final stored procedure question, for now anyway

Поиск
Список
Период
Сортировка
От Guy Rouillier
Тема Re: Final stored procedure question, for now anyway
Дата
Msg-id CC1CF380F4D70844B01D45982E671B239E8DC0@mtxexch01.add0.masergy.com
обсуждение исходный текст
Ответ на Final stored procedure question, for now anyway  ("Ted Byers" <r.ted.byers@rogers.com>)
Список 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 по дате отправления:

Предыдущее
От: merlyn@stonehenge.com (Randal L. Schwartz)
Дата:
Сообщение: Re: sending mail from Postgres
Следующее
От: "Jonel Rienton"
Дата:
Сообщение: Re: Final stored procedure question, for now anyway