Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #4741: Domain constraint violation with trigger - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #4741: Domain constraint violation with trigger
Date
Msg-id 3907.1238635062@sss.pgh.pa.us
Whole thread Raw
In response to BUG #4741: Domain constraint violation with trigger  ("Brice Maron & Duchesne P-A" <bmaron@naturalsciences.be>)
List pgsql-bugs
Tree view 
"Brice Maron & Duchesne P-A" <bmaron@naturalsciences.be> writes:
> we've got a problem with a NOT Null constraint on a domain in a trigger.
> When, in a trigger, we put a null into the not nullable domain, postgresql
> doesn't throw an error.

Thanks, fixed.  (Just remove the if (!isnull) test in exec_simple_cast_value())

            regards, tom lane

pgsql-bugs by date:

Previous
From: Beto Piragauta
Date:
Subject: consulta de phpESP postgres error
Next
From: itishree sukla
Date:
Subject: Re: [GENERAL] Hello, i want to subscribe...