Tom Lane wrote:
Bill <[EMAIL PROTECTED]> 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
