Tom Lane wrote:
Bill <pg@dbginc.com> 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