Re: Searching through trigger functions

Поиск
Список
Период
Сортировка
От Merlin Moncure
Тема Re: Searching through trigger functions
Дата
Msg-id CAHyXU0wKQGd+=WuXU7FNfD-roog8d8dQQS7o0x=POGqoDHV0Tg@mail.gmail.com
обсуждение исходный текст
Ответ на Searching through trigger functions  ("Bob Pawley" <rjpawley@shaw.ca>)
Список pgsql-general
On Mon, Sep 26, 2011 at 12:47 PM, Bob Pawley <rjpawley@shaw.ca> wrote:
> Hi
>
> I have an error somewhere in one of the trigger functions in my database.
> The error message only told me it was a ‘Select * From (table name).
>
> Is there a global method of finding where this expression resides other than
> searching each script individually.

all function bodies are in pg_proc.prosrc.  search that...

merlin

В списке pgsql-general по дате отправления:

Предыдущее
От: "Bob Pawley"
Дата:
Сообщение: Searching through trigger functions
Следующее
От: Alan Hodgson
Дата:
Сообщение: Re: Searching through trigger functions