Calling triggers with arguments - Mailing list pgsql-general

From Christopher Murtagh
Subject Calling triggers with arguments
Date
Msg-id 1074896012.21097.4.camel@brahma.wcg.mcgill.ca
Whole thread Raw
Responses Re: Calling triggers with arguments
Powerbuilder and PostgreSQL information
List pgsql-general
Greetings,

 I've come across something that either doesn't work spec'd or I'm
missing something (I suspect the latter). I'm trying this:


  CREATE TRIGGER classified_index_trigger
  BEFORE INSERT OR UPDATE ON ads
  FOR EACH ROW
  EXECUTE PROCEDURE htdig_index('classified_en');

and the error message I get is:

  ERROR:  function htdig_index() does not exist

However if I do \df htdig_index I get this:

                       List of functions
 Result data type | Schema |    Name     | Argument data types
------------------+--------+-------------+---------------------
 "trigger"          | public | htdig_index | text


Is there something I'm missing in order to pass an argument in a
trigger?  I've tried double quotes, and two singles as well as no
quotes, and all lead to the same thing.

 Any info would be much appreciated.

Cheers,

Chris

--
Christopher Murtagh
Enterprise Systems Administrator
ISR / Web Communications Group
McGill University
Montreal, Quebec
Canada

Tel.: (514) 398-3122
Fax:  (514) 398-2017

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Article in German iX magazine
Next
From: Doug McNaught
Date:
Subject: Re: Calling triggers with arguments