Re: Trigger function is not called - Mailing list pgsql-general

From Tom Lane
Subject Re: Trigger function is not called
Date
Msg-id 8821.1219706342@sss.pgh.pa.us
Whole thread Raw
In response to Trigger function is not called  (Bill <pg@dbginc.com>)
Responses Re: Trigger function is not called  (Bill <pg@dbginc.com>)
List pgsql-general
Bill <pg@dbginc.com> writes:
> PostgreSQL 8.3 on Windows. I have the table below which has a before
> insert trigger. The CREATE TRIGGER statement and the trigger function
> are also shown below.

The script you show attempts to create the trigger before creating the
function, which of course isn't going to work.  Did you check whether
the trigger actually got created?

            regards, tom lane

pgsql-general by date:

Previous
From: "John T. Dow"
Date:
Subject: Re: Dump/restore with bad data and large objects
Next
From: Bill
Date:
Subject: Re: Trigger function is not called