Re: Searching through trigger functions

From: Merlin Moncure <mmoncure(at)gmail(dot)com>
To: Bob Pawley <rjpawley(at)shaw(dot)ca>
Cc: Postgresql <pgsql-general(at)postgresql(dot)org>
Subject: Re: Searching through trigger functions
Date: 2011-09-26 17:50:45
Message-ID: CAHyXU0wKQGd+=WuXU7FNfD-roog8d8dQQS7o0x=POGqoDHV0Tg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, Sep 26, 2011 at 12:47 PM, Bob Pawley <rjpawley(at)shaw(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Alan Hodgson 2011-09-26 17:53:00 Re: Searching through trigger functions
Previous Message Bob Pawley 2011-09-26 17:47:20 Searching through trigger functions