Postgres Pro
Downloads
Home   >   mailing lists

Re: abnormal behaviour of a CHECK CONSTRAINT with a regular expression when a trigger is added - Mailing list pgsql-bugs

From Tom Lane
Subject Re: abnormal behaviour of a CHECK CONSTRAINT with a regular expression when a trigger is added
Date
Msg-id 15074.1076427520@sss.pgh.pa.us
Whole thread Raw
In response to abnormal behaviour of a CHECK CONSTRAINT with a regular expression when a trigger is added  (Daniel Struck <struck.d@retrovirology.lu>)
Responses Re: abnormal behaviour of a CHECK CONSTRAINT with a regular
List pgsql-bugs
Tree view 
Daniel Struck <struck.d@retrovirology.lu> writes:
> I think I have found a bug in postgresql:

I don't see any bug here; it's just that CHECK constraints are applied
after any BEFORE triggers are run.  Since the triggers could change the
data to be inserted, the reverse order would be insecure.

            regards, tom lane

pgsql-bugs by date:

Previous
From: John Siracusa
Date:
Subject: Re: Expected regression test difference on Mac OSX...
Next
From: Tom Lane
Date:
Subject: Re: abnormal behaviour of a CHECK CONSTRAINT with a regular expression when a trigger is added