Re: Trigger function is not called

[Bill <pg@xxxxxxxxxx>]

Tom Lane wrote:

Bill <pg@xxxxxxxxxx> writes:
  

In a newsgroup posting someone suggested that constraint checks on 
domains occur before the before insert trigger.
    

Yeah, that is the case, but if a domain check was failing then the
row wouldn't get inserted, so I'm not clear on how this matches up
with your report.

			regards, tom lane


  

The row is not getting inserted. I just created a test table and trigger and confirmed that the trigger fires if the column is defined as bigint not null and fails after I change the type to the domain. I will alter all of the tables and get rid of the domain.

Is it possible to create a type and use that instead of the domain or will I have the same problem with a type?

Bill