Searching through trigger functions

From: "Bob Pawley" <rjpawley(at)shaw(dot)ca>
To: "Postgresql" <pgsql-general(at)postgresql(dot)org>
Subject: Searching through trigger functions
Date: 2011-09-26 17:47:20
Message-ID: 5ED9ECF3D7144D8A9D27A8665E268148@BobPC
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Bob

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Merlin Moncure 2011-09-26 17:50:45 Re: Searching through trigger functions
Previous Message Edson Carlos Ericksson Richter 2011-09-26 17:00:47 RES: Does postgresql 9.0.4 use index on PREFIX%SUFFIX queries?