Re: abnormal behaviour of a CHECK CONSTRAINT with a regular expression when a trigger is added

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Daniel Struck <struck(dot)d(at)retrovirology(dot)lu>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: abnormal behaviour of a CHECK CONSTRAINT with a regular expression when a trigger is added
Date: 2004-02-10 15:38:40
Message-ID: 15074.1076427520@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Daniel Struck <struck(dot)d(at)retrovirology(dot)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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Daniel Struck 2004-02-10 16:08:58 Re: abnormal behaviour of a CHECK CONSTRAINT with a regular
Previous Message John Siracusa 2004-02-10 15:10:41 Re: Expected regression test difference on Mac OSX...